I have tried to do this before one temp table function at a time, but I think I need to try something different In this video, we will go from the simplest table functions like ROW() to more sophisticated ones like GENERATE, SUMMARIZE, ADDCOLUMNS, NATURALINNERJOIN and a few others. I think that unless you go … Continue reading Comprehensive DAX Table Functions Tutorial (GENERATE, SUMMARIZE, ADDCOLUMNS, NATURALINNERJOIN and more… )
Category: Power BI
Why DAX SUM() Function is Broken and How to Fix It
This is not a click bait – the SUM() function in DAX is indeed broken in my opinion. Just try to add a calculated column with a SUM(…) of another column in the create column formula and then do the same but with a CALCULATE(SUM(…)) and you will see that these will produce two absolutely … Continue reading Why DAX SUM() Function is Broken and How to Fix It
Top Performers Analysis + Generate() and TopN() Tutorial
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
Better Income Statement with Calculation Groups? (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)
Finally!!! We Can Now Format The Same Measure as % OR $ on the Same Trend Chart (calculation groups bug is fixed!)
I knew this moment would come, but I did not know when. We are now able to have a smart measure that can be displayed as any valid number format on our chart, $$ or %, or even whole dollars All it took was for me to raise a bug with Microsoft about the formatting … Continue reading Finally!!! We Can Now Format The Same Measure as % OR $ on the Same Trend Chart (calculation groups bug is fixed!)
Improve Slice and Dice End User Experience for Tables with Multiple Dates (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)
How to Show Today on a Trend Chart (quick DAX 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
Power BI DAX Tutorial: How to PIVOT Data Using DAX (using RANK.EQ function)
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)
DAX Tutorial: Average Days Between Orders
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
DAX Tutorial: How to Count Things That Did Not Happen?
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?
business intelligist 