Microsoft · PL-300
Time intelligence and advanced DAX
PL-300 · Lesson 7 of 15 · 44:49
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the PL-300 exam (Microsoft Certified: Power BI Data Analyst Associate). In this lesson: TOTALYTD, SAMEPERIODLASTYEAR, and DATEADD, calendar-based time intelligence in preview, semi-additive measures with LASTNONBLANK, basic statistical functions, and calculation groups with SELECTEDMEASURE. Includes three original practice questions.
Preview the topics
- A measure must return the sales of the same month one year earlier, for each month of a matrix. The Date table is marked as a date table. Which expression fits?
- Account balances are stored for every business day, but never for weekends. A measure must show each month’s closing balance, even when the month ends on a Sunday. Which function should pick the date?
- Finance wants year to date and prior year versions of twelve existing measures, without writing twenty-four new measures. What should the modeler create?