Question 590
A data analyst is planning a Power BI solution. The business says: A date slicer uses a collection of dates with missing days, and time-intelligence calculations require a continuous range. Which step best satisfies this request?
Explanation
Correct Answer
This directly addresses the stated constraint. A proper date dimension should have a continuous distinct date column. Confirmation: Year-to-date results include the expected continuous calendar timeline, including dates without sales.
Incorrect Answers
Replacing the logic with a static calculated column changes slicer responsiveness. The specific problem here is that using only existing transaction dates can omit days and break expected date calculations.
Joining annual budget directly to each daily actual line replicates budget amounts and inflates totals. The specific problem here is that using only existing transaction dates can omit days and break expected date calculations.
AVERAGE(Sales[NetAmount]) produces mean line revenue, not mean order value. The specific problem here is that using only existing transaction dates can omit days and break expected date calculations.