Power BI Data Modelling: Build a Star Schema (and Why Your Report Is Slow Without One)
Learn the star schema for Power BI: fact and dimension tables, one-to-many relationships, filter direction, a proper date table, and how to turn a…
Read article →Category Archives: Power BI & DAX
Power BI Desktop, data modelling and DAX measures explained for Excel users.
DAX CALCULATE Explained: Filter Context Without the Headache
DAX CALCULATE Explained: Filter Context Without the Headache
A deep, practical guide to CALCULATE in Power BI and Power Pivot: filter context, row context, ALL, REMOVEFILTERS, KEEPFILTERS, time intelligence and the patterns…
Read article →