Power BI DAX Intermediate: Ranking, Logic, Time Intelligence

Enhance Your Power BI Data Modeling With DAX—Master Ranking, Logic, Time Intelligence, and Dynamic Report Design

What you'll learn
- Use intermediate DAX functions like RANKX, SWITCH, and USERPRINCIPALNAME in Power BI reports
- Build dynamic titles, tooltips, and charts that adapt to filters and user identity in Power BI dashboards
- Apply logic, conditional formatting, and dynamic visuals using powerful Power BI DAX techniques
- Create time intelligence measures for YTD, MTD, and comparisons to track trends, monitor growth, and improve decision-making in Power BI

Requirements
- A basic understanding of Power BI and DAX formulas (e.g. CALCULATE, SUM, FILTER).
- Completion of a beginner DAX course or hands-on experience writing simple DAX measures.

Description
Ready to level up your Power BI data modeling skills and write DAX like a pro? This course is your step-by-step guide to mastering intermediate DAX techniques — the kind that transform reports from functional to exceptional and enhance your data modeling workflow.

In this hands-on, business-focused course, you’ll move beyond basic measures and calculated columns to discover how DAX can drive intelligent, responsive, and personalised Power BI experiences. Across six structured chapters, you’ll explore the full breadth of intermediate DAX capabilities — from dynamic titles and user-aware filters to row-level security, advanced logic, iterators, rankings, formatting, and time intelligence.

We begin with dynamic report elements, showing you how to use functions like SELECTEDVALUE, USERPRINCIPALNAME, and FORMAT to generate titles, search URLs, and personal commentary that adapt to the user and context. You’ll then master logical patterns with nested IF statements, compound conditions, and the powerful SWITCH(TRUE()) structure — making your measures flexible and context-aware.

Next, we take a deep dive into iterator functions like MAXX, MINX, and CONCATENATEX, before demystifying EARLIER and its modern replacement using VAR. These lessons will deepen your understanding of row context and strengthen your grasp of effective data modeling techniques in Power BI.

In the ranking section, you’ll build sophisticated comparisons using RANKX, TOPN, and optional arguments that control ties and sort order — all vital tools for leaderboard-style reports. You’ll also learn how to apply conditional formatting and visual storytelling using UNICHAR, RAG status logic, and dynamic KPIs.

Finally, we dedicate a full chapter to DAX time intelligence: running totals, prior period comparisons, and calendar-aware measures using DATEADD, SAMEPERIODLASTYEAR, DATESYTD, and more. You’ll understand how to build and customise your own calendar tables and apply time-based filters to uncover trends and seasonality.

By the end of the course, you won’t just be writing better DAX — you’ll be building smarter data models, designing user-responsive reports, and confidently applying best practices that scale. This is the course that turns competent Power BI users into powerful DAX creators.

Who this course is for:
- Power BI users ready to move beyond basic measures into smarter, dynamic reporting
- Data analysts, report developers, and professionals aiming to master real-world DAX techniques
- Anyone preparing for Power BI-related roles or certifications and wanting deeper DAX skills
- Data scientists looking to broaden their skillset to include Power BI and DAX skills for more flexible, self-service business reporting and data storytelling
- Professionals preparing for Microsoft’s PL-300 certification who want deeper coverage of intermediate DAX patterns and report modelling
- Excel power users transitioning to Power BI and needing to understand context, row-level logic, and advanced DAX functions
More Info