Create model calculations by using DAX
6 practice questions under this official exam objective (PL-300) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
Building a rolling 31-day sales total with DATESBETWEEN in DAX
A Sales table relates to a Date table many-to-one, and a measure must return the total sales amount for a selected date plus the previous 30 days, so
Averaging item price per country while preserving report filters with a quick measure
A report filtered by item, price, and country data must calculate the average item price for a given country while keeping the existing filters, so th
Averaging Sales department salaries with CALCULATE and a department filter
An Employees table lists staff by ID, name, department, and salary, and a measure must return the average salary of employees in the sales department
INTERSECT returns rows of its first table that appear in the second
A calculated table defined as INTERSECT(ProductsGroupA, ProductsGroupB) must be evaluated to know which rows appear in the result.
PREVIOUSYEAR returns the full previous year, not the same day of last year
A card visual shows a Previous Year Sales measure using CALCULATE with PREVIOUSYEAR while the report page filters to May 9, 2024, so the displayed val
USERELATIONSHIP measures over inactive relationships support all three date roles
In the three-date-foreign-key scenario (Due Date, Order Date, Delivery Date), the proposed solution creates measures that use the USERELATIONSHIP func