← All postsTopic
Best Practices
3 posts on Best Practices: benchmarks, internals and workarounds for the Microsoft data stack.
- 03Stop Repeating CALCULATE: Iterate Over Categories in DAX
Stop repeating CALCULATE in your DAX. Discover how to iterate and simplify category-level logic with SUMX, AVERAGEX, and virtual tables like VALUES and SUMMARIZE.
- 02Make Your Power Query Dynamic with Parameters
Discover how to make your Power Query dynamic with parameters. Learn practical ways to use parameters in Power BI, enhancing flexibility and control.
- 01Top everyday DAX functions
The DAX functions worth learning first and what each one is actually for. Not a reference list: the handful you end up using in every model.
3 postsAll posts →