DAX CALCULATE and time intelligence

PL-300 · Model the data · Updated

Filter context, CALCULATE, ALL and REMOVEFILTERS, iterators, and time intelligence like SAMEPERIODLASTYEAR and TOTALYTD.

This lesson is part of full PL-300 access

The first 2 PL-300 lessons are free. Full access opens every lesson with its practice questions, and the exam-style PL-300 question bank.

In this lesson
  • Filter context
  • CALCULATE
  • Iterators
  • Time intelligence
  • Other functions to know
  • Exam traps
  • Practice questions

Get full access Try the free practice exam Log in

PL-300 course outline

All 7 lessons · Course overview
  1. Shaping data in Power QueryPrepare the data Free
  2. Storage modes and data connectionsPrepare the data Free
  3. Star schema and relationshipsModel the data Full access
  4. DAX CALCULATE and time intelligenceModel the data Full access
  5. Choosing visuals and AI insightsVisualize and analyze the data Full access
  6. Workspaces, apps and row-level securityManage and secure Power BI Full access
  7. Dashboards, alerts and refresh in the serviceManage and secure Power BI Full access