There are a lot of small but powerful things hidden inside DAX and Power BI, and in this blog I walk through 3 such tricks that can genuinely improve the way your reports look and behave.
We cover:
• Dynamic format strings in DAX to go beyond default measure formatting
• A clever way to sort months without a month number column
• How to find max values by different granularities using iterator functions like MAXX
Along the way, I also talk about the caveats of each trick, because some of these are powerful but should still be used carefully.
If you work with Power BI, DAX, dynamic formatting, custom visuals, time intelligence, or iterator functions, this video will give you a few useful ideas you can start applying right away.
