How often does our customer place an order with us? This is a common business scenario, therefore, I decided to cover it in another DAX Tutorial. There are two ways this question can be posed: How many days on average does it take the customer to place another order? How often does the customer order … Continue reading DAX Tutorial: Average Days Between Orders

We already know how to analyze things that happened because for every occurrence we have a record in the fact table that tracks that event. What do we do to analyze things that did not happen? For example, what if I am looking at my sales data and trying to figure out what products are … Continue reading DAX Tutorial: How to Count Things That Did Not Happen?

This is a fun tutorial where we will learn how to calculate average of the highest values that might be spread across different time periods. A good example is figuring out what would be a good proxy for the highest temperature for IL in July. If we simply take one reading for the highest day … Continue reading Tutorial: How to Calculate an Average of the Best using AVERAGEX() and ADDCOLUMNS() Functions

This is a fun little tutorial that will give you another chance to practice you CALCULATE() and FILTER() functions skills. Running totals are a common problem that we have to deal with. To illustrate this problem, I created a sales dataset for innovation products. In our example, after the product reaches $1m in global sales … Continue reading Getting Better at DAX: Having Fun with Running Totals

This is a fun video in which we try to solve an interesting DAX puzzle while learning how to use TREATAS() DAX function. As a bonus I also show you how to debug variables that house a table inside. For that I do a bit of a tutorial on CANCATINATEX() function. The data set is … Continue reading Getting Better at DAX: Understanding TREATAS() Function

I know these are not the most politically correct words; however, we cannot build a real Income Statement in Power BI the way we can in Excel. The best we can do is put together something that looks like an Income Statement and hope that our CFO will accept it, knowing very well, that there … Continue reading How to Fake an Income Statement in Power BI (Tutorial)

The title is pretty self-explanatory, the two Power BI DAX titans are going to collide in this video. Two functions enter the arena but only one will leave... Well, obviously, I am only kidding… The two functions have drastically different purposes and objectives and by the end of the video you will have all the … Continue reading Power BI & DAX: HASONEVALUE() vs. HASONEFILTER()

If you have tried to use the default Power BI waterfall chart to recreate your PowerPoint variance bridge but got frustrated because you were not able to show from and to values along with your variances, then you are in luck, because in this video I will show you how you can build any variance … Continue reading Power BI & DAX: How to Make Waterfall Charts Work (showing starting and ending values)