Learn advanced Power BI
Step-by-step lessons on the advanced parts of Power BI, with clear explanations, working examples and the mistakes to avoid.
-
DAX user-defined functions
Write a DAX calculation once and reuse it everywhere.
Start reading -
Calculation groups
Reusable calculation items, like Year to date, applied to any measure.
Start reading -
Power BI Projects (PBIP), TMDL, PBIR, Git and CI/CD
Store reports and models as plain text files you can version in Git.
Start reading -
Direct Lake semantic models
Query Delta tables in OneLake straight from memory.
Start reading -
Composite models
Mix storage modes and sources in one semantic model.
Start reading -
Visual calculations
Write DAX directly on a visual, with no model measure needed.
Start reading -
DAX window functions
Pick rows by position: the previous row, the first row, the last three.
Start reading -
Calendar-based time intelligence (preview)
Define any calendar in the model and pass it to time functions.
Start reading -
Performance tuning with Performance Analyzer, DAX query view and DAX Studio
A repeatable loop to find and fix slow reports.
Start reading