Category: Business Intelligence

Show Results Up To Current Date Or A Specific Date In Power BI

In this tutorial, I’m going to show you a very simple technique where you can show data up to a specific date or just up to today inside of your Power BI reports. This came from a recently requested question from the Enterprise DNA Support Forum, Personally, I’ve also used this technique many times so

Continue reading

How To Calculate The MEDIAN Value In Power BI Using DAX

Calculate The MEDIAN Value In Power BI - Statistical Analysis wDAX

In this tutorial, I want to show you how we can calculate the median value from a list of values that we have inside of Power BI. With a lot of the statistical functions that we can use in DAX, there is a need to understand how they calculate and how they operate over tables

Continue reading

Show Last N Sales Of A Customer Only Using Power BI

We are going to go through quite an advanced tutorial here utilizing┬áDAX formulas in Power BI What I want to show you is how we can work out; how many sales we have made from a specific customer….but, we only want to look at the last three sales or last N number of sales rather

Continue reading

Normalizing Results On Different Days In Power BI Using DAX

Normalizing Results On Different Days In Power BI Using DAX

Occasionally when running analysis in Power BI, you may need to take into account weekends or public holidays where there is no data. When there is no data, it can make your visualizations look a little bit off. That’s where this normalizing technique comes into play…where you might need to normalize, for example, sales amounts

Continue reading

How To Create Virtual Relationships Using TREATAS In Power BI

How To Create Virtual Relationships Using TREATAS In Power BI

The TREATAS function in DAX is one of the most interesting DAX formulas that you can utilise inside of your Power BI models. It’s only been around for the last couple of years and it has a very specific usage which can become very beneficial if you are looking to simplify your data model and

Continue reading