Comprehensive DAX Table Functions Tutorial (GENERATE, SUMMARIZE, ADDCOLUMNS, NATURALINNERJOIN and more… )

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… )

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)

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)