Microsoft · PL-300
Design the data model
PL-300 · Lesson 5 of 15 · 33:36
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: relationship cardinality and cross-filter direction, table and column properties like Sort by column and Summarize by, role-playing dimensions with USERELATIONSHIP, and a marked common date table. Includes three original practice questions.
Preview the topics
- Monthly targets are stored by product category, so each category appears once per month. The Product table has one row per product, and many products share a category. How should the Target table relate to the Product table?
- Whenever an author drags the Year column of the Date table into a visual, it appears as a sum, like 4,048. What should the modeler change?
- A Sales table has an order date key and a ship date key, both related to the Date table, and the ship date relationship is inactive. A measure must total sales by ship date. What should the measure use?