Free Microsoft Power BI PL-300 Actual Exam Questions - Question 3 Discussion
DRAG DROP You need to create a date table in Power B1 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. 
I’m thinking the start date should definitely be January 1 of (Year(Today()) - 9) because that covers the full 10 years including this year, and the end date should be December 31 of the current year.
I see why some are unsure about the direction, but since it says “10 full calendar years including the current year,” I’d go with starting from January 1st of 9 years ago up to December 31st of the current year. That way, you get a total of 10 full years. So for the DAX, using something like STARTOFYEAR(TODAY()) minus 9 years for the start date and ENDOFYEAR(TODAY()) for the end makes sense. It covers the full span and includes the current year without going into the future.
I think the range should start from the first day of 10 years ago to the last day of the
Anyone else confused about whether the date range should start from the current year going backwards or forward for 10 years? The question says “including current year,” but doesn’t clarify if it wants past 10 years, next 10 years, or a mix. Also, what’s the significance of the first argument in CALENDAR? Is it supposed to be a static date or derived dynamically? Would appreciate if someone can clarify that before we pick the values to drag!