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.

  1. DAX user-defined functions

    Write a DAX calculation once and reuse it everywhere.

    Start reading
  2. Calculation groups

    Reusable calculation items, like Year to date, applied to any measure.

    Start reading
  3. 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
  4. Direct Lake semantic models

    Query Delta tables in OneLake straight from memory.

    Start reading
  5. Composite models

    Mix storage modes and sources in one semantic model.

    Start reading
  6. Visual calculations

    Write DAX directly on a visual, with no model measure needed.

    Start reading
  7. DAX window functions

    Pick rows by position: the previous row, the first row, the last three.

    Start reading
  8. Calendar-based time intelligence (preview)

    Define any calendar in the model and pass it to time functions.

    Start reading
  9. Performance tuning with Performance Analyzer, DAX query view and DAX Studio

    A repeatable loop to find and fix slow reports.

    Start reading