Power BI Intermediate Lesson 10: Project – Sales Performance vs Target
Final project: targets without a relationship via TREATAS, % of target with status, months above average, FYTD trend and an RLS-ready one-page report.
Read article →Power BI & DAX
Power BI Desktop, data modelling and DAX measures explained for Excel users.
📈
← Excel
Power BI & DAX
Power BI Desktop, data modelling and DAX measures explained for Excel users.
📄 23 articles⬇️ 23 with practice files🕒 Updated 12 Oct 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →Power BI Intermediate Lesson 9: Drill-Through, Tooltip Pages and Bookmarks
Power BI Intermediate Lesson 9: Drill-Through, Tooltip Pages and Bookmarks
Make reports explorable: right-click drill-through to a customer page, report-page tooltips with a mini chart, and bookmarks with buttons to switch views.
Read article →Power BI Intermediate Lesson 8: Row-Level Security (Static and Dynamic)
Power 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 with View…
Read article →Power BI Intermediate Lesson 7: Dynamic Titles and Field Parameters
Power BI Intermediate Lesson 7: Dynamic Titles and Field Parameters
Titles that say what is selected with SELECTEDVALUE, and one chart that switches between Sales, Profit and Orders with a field parameter.
Read article →Power BI Intermediate Lesson 6: Two Dates – Inactive Relationships and USERELATIONSHIP
Power BI Intermediate Lesson 6: Two Dates – Inactive Relationships and USERELATIONSHIP
Report sales by order date and by ship date from one Date table with an inactive relationship and USERELATIONSHIP, plus days-to-ship and cross-year orders.
Read article →Power BI Intermediate Lesson 5: Variables, DIVIDE and Readable DAX
Power BI Intermediate Lesson 5: Variables, DIVIDE and Readable DAX
Write DAX that others can read and debug: VAR/RETURN, DIVIDE instead of /, RELATED in iterators, and a discount analysis on list vs selling…
Read article →Power BI Intermediate Lesson 4: Iterators – SUMX, AVERAGEX and RANKX
Power BI Intermediate Lesson 4: Iterators – SUMX, AVERAGEX and RANKX
Row-by-row calculations with SUMX for profit, AVERAGEX for averages per customer, and RANKX for top-N rankings that respect filters.
Read article →Power BI Intermediate Lesson 3: Time Intelligence for the April-March Financial Year
Power BI Intermediate Lesson 3: Time Intelligence for the April-March Financial Year
FYTD, last year and YoY % for an Indian April-March financial year with TOTALYTD and "3/31", SAMEPERIODLASTYEAR and a proper Date table.
Read article →Power BI Intermediate Lesson 2: % of Total With ALL, ALLEXCEPT and REMOVEFILTERS
Power BI Intermediate Lesson 2: % of Total With ALL, ALLEXCEPT and REMOVEFILTERS
Region share of total, product share within its category and grand-total percentages that stay correct under slicers, with REMOVEFILTERS, ALL and ALLEXCEPT.
Read article →Power BI Intermediate Lesson 1: CALCULATE and Filter Context
Power BI Intermediate Lesson 1: CALCULATE and Filter Context
How CALCULATE adds and replaces filters, why a measure gives different results in each cell, and when KEEPFILTERS returns blank.
Read article →Power BI Lesson 2: The Data Model — Facts, Dimensions and a Star Schema
Power BI Lesson 2: The Data Model — Facts, Dimensions and a Star Schema
Design a Power BI model that works: fact tables vs dimension tables, why a star schema beats one big flat table, keys, a Calendar…
Read article →Power BI Lesson 6: CALCULATE and Filter Context
Power BI Lesson 6: CALCULATE and Filter Context
Understand filter context, then change it with CALCULATE: sales for one category, ignore a filter with ALL and REMOVEFILTERS, share of total, and the…
Read article →