Time intelligence is what separates a basic report from a dashboard that actually drives decisions. In this chapter, you'll write four time-based measures: Sales YTD (cumulative year-to-date revenue), Sales PY (same period last year), YoY Change (the dollar difference), and YoY Pct Change (the percentage difference).

You write the measure `Sales YTD = TOTALYTD([Total Sales], 'Date'[Date])`. A user selects `March 2024` in a slicer. What period does `Sales YTD` cover?

Master the skills needed to turn raw data into professional, interactive reports using Power BI. You'll connect to data sources, clean and transform data with Power Query, build data models, write DAX measures, and publish polished dashboards to Power BI Service. No prior experience required.

Time Intelligence