You need to create a date table in Power BI that must contain 10 full calendar years, including the current year How should you complete the DAX expression? To answer, drag the appropriate values to the correct locations. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content NOTE: Each correct selection is worth one point.

Reveal Solution
Discussion
Correct Answer:

Explanation:

The retained answer-area mapping contains the correct selections. The key constraint is to create a date table in Power BI that must contain 10 full calendar years, including the current year. A text month or an incomplete date column cannot supply a reliable chronological hierarchy or the contiguous dates expected by time-intelligence calculations. A dedicated, contiguous date table supports month, quarter, and year analysis consistently. Marking it as a date table tells Power BI which column represents the model ' s canonical dates.
In Microsoft ' s current exam outline, the corresponding objective is " Create a common date table " . It also preserves predictable filter context and aggregation behavior when the result is used by several visuals or report pages.
Microsoft Learn reference: https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-date-tables | PL-300 objective: " Create a common date table " | Study guide: https://learn.microsoft.com/en-us/credentials
/certifications/resources/study-guides/pl-300