Ok, I have to admit, this is not a level 100 kind of stuff, things get a little complicated, but if you manage to sit through the entire thing, I think it will be worth your while. The problem is the following - we have a sales table tracking Sales Amount by Date, Product, and … Continue reading Top Performers Analysis + Generate() and TopN() Tutorial

A short while ago I did a video about how hard it was (or almost impossible) to build a good Income Statement in Power BI. Now that the Calculation Groups are here, the question is whether we have a better option than what I had to do before with a smart calculation. If you are … Continue reading Better Income Statement with Calculation Groups? (tutorial)

Slice and Dice experience on a table with multiple dates can be a little frustrating. If I have two date tables connected to my two date columns in the transaction table (so if I have a list of projects, Project Start Date and Project End Date), and if I create two filters at the same … Continue reading Improve Slice and Dice End User Experience for Tables with Multiple Dates (tutorial)

Let's say that you have a trend chart, and let's say that you would like to make it easier for a user to see where today's date is on that chart. If that sounds like a useful feature to have, then give this short video a listen and download all the materials here.   https://youtu.be/pqVbdhMe53U

Little known fact, I used to box, and boxed a lot… Unfortunately, it did little to help me with my public speaking as you will definitely be able to see from this video where I constantly say UNPIVOT instead of PIVOT. My apologies, hopefully, you will be able to enjoy the video anyway as the … Continue reading Power BI DAX Tutorial: How to PIVOT Data Using DAX (using RANK.EQ function)

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