Power BI Intermediate Course: DAX, Time Intelligence and Real Reports

You can build visuals and simple measures. This course is about getting the numbers right: how CALCULATE changes filters, percentages of total, the April-March financial year in time intelligence, iterators like SUMX and RANKX, variables, two date relationships, dynamic titles and field parameters, row-level security, drill-through and tooltip pages, and a final sales vs target report.

One two-year practice model (700 orders across four regions, with targets and ship dates), a .dax file per lesson, and an expected-results workbook to check every measure.

Before you start: the Power BI & DAX Beginner Course. Power BI Desktop is free for Windows.

1. 1Power BI Intermediate Lesson 1: CALCULATE and Filter ContextHow CALCULATE adds and replaces filters, why a measure gives different results in each cell, and when KEEPFILTERS returns blank.
2. 2Power BI Intermediate Lesson 2: % of Total With ALL, ALLEXCEPT and REMOVEFILTERSRegion share of total, product share within its category and grand-total percentages that stay correct under slicers, with REMOVEFILTERS, ALL and ALLEXCEPT.
3. 3Power BI Intermediate Lesson 3: Time Intelligence for the April-March Financial YearFYTD, last year and YoY % for an Indian April-March financial year with TOTALYTD and "3/31", SAMEPERIODLASTYEAR and a proper Date table.
4. 4Power BI Intermediate Lesson 4: Iterators – SUMX, AVERAGEX and RANKXRow-by-row calculations with SUMX for profit, AVERAGEX for averages per customer, and RANKX for top-N rankings that respect filters.
5. 5Power BI Intermediate Lesson 5: Variables, DIVIDE and Readable DAXWrite DAX that others can read and debug: VAR/RETURN, DIVIDE instead of /, RELATED in iterators, and a discount analysis on list…
6. 6Power BI Intermediate Lesson 6: Two Dates – Inactive Relationships and USERELATIONSHIPReport sales by order date and by ship date from one Date table with an inactive relationship and USERELATIONSHIP, plus days-to-ship and…
7. 7Power BI Intermediate Lesson 7: Dynamic Titles and Field ParametersTitles that say what is selected with SELECTEDVALUE, and one chart that switches between Sales, Profit and Orders with a field parameter.
8. 8Power BI Intermediate Lesson 8: Row-Level Security (Static and Dynamic)Show each regional manager only their region's data: static roles, dynamic RLS with USERPRINCIPALNAME and a user table, and how to test…
9. 9Power BI Intermediate Lesson 9: Drill-Through, Tooltip Pages and BookmarksMake reports explorable: right-click drill-through to a customer page, report-page tooltips with a mini chart, and bookmarks with buttons to switch views.
10. 10Power BI Intermediate Lesson 10: Project – Sales Performance vs TargetFinal project: targets without a relationship via TREATAS, % of target with status, months above average, FYTD trend and an RLS-ready one-page…

Prepare data for Power BI in the Power Query Intermediate Course, or query the source with the SQL Intermediate Course.