Power BI Pro Tip: show 0 instead of (Blank)
Default behavior of Power BI is to show (Blank) even when summing a numerical column that happens to be all empty. Want to show 0 instead? COALESCE helps.
Ultimate Time Based Calculations Cheat Sheet for DAX / Power BI (including Week based calculations)
Power BI provides great time intelligence features to calculate Year-to-date (YTD), Month-to-date (MTD) and Quarter-to-date (QTD) totals. There is no such thing as Week-to-date (WTD) or Period-to-date (PTD) where period could be any arbitrary period definition (I…
Power BI Pro Tip: Pareto analysis with DAX / Power Pivot
Today’s post is a guest post by Michiel Rozema (https://www.linkedin.com/in/michielrozema). Thanks Michiel! Dutch Data Dude Jeroen approached me with the question whether it would be possible to create a Pareto chart from a Power Pivot model, using…
Power BI Pro Tip: making date / time calculations work (Time Intelligence)
Ever so often I get asked how to do a year-over-year, quarter-over-quarter, month-over-month or year-vs-year calculation in Power BI. In most cases people would like to create a KPI to measure a certain periods performance compared to…
Power BI Pro Tip: Confusion about TOPN() versus RANKX()
This post serves as a follow-up on my Power BI Pro Tip about using RANKX to show Top X results. I am writing this because I discovered that there is a lot of confusion about the RANKX()…