Microsoft · DP-600
Windows, calculation groups, and field parameters
DP-600 · Lesson 13 of 15 · 1:20:58
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 DP-600 exam (Microsoft Certified: Fabric Analytics Engineer Associate). In this lesson: window functions like OFFSET, INDEX, and WINDOW, calculation groups, dynamic format strings, and field parameters. Includes three original practice questions.
Preview the topics
- A measure must average the sales of the current month and the two months before it, in a monthly visual. Which function returns those three months?
- A team needs year to date, prior year, and growth versions of twelve measures, without writing thirty-six new measures. What should it build?
- Readers want one chart, where a slicer switches the measure between revenue, margin, and quantity, without any bookmark. What should the author create?