MDFT Academy requires a date table that starts from Feb 2015 and ends in Dec 2030. This is needed to ensure all reports and analyses use a consistent date range across the organization.
How should you complete the DAX expression to create a date table for this custom range?
Choose the correct answer from the options below.
Please select at least one answer!
Correct!
I'm sorry, your answer is not correct.
Explanations for each answer:
Date = CALENDAR(DATE(2015, 02, 01), DATE(2030, 12, 31)) is correct. CALENDAR with DATE arguments creates a date table for the specified range, from Feb 2015 to Dec 2030.
Date = CALENDARAUTO(4) is incorrect. CALENDARAUTO(4) creates a date table with a fiscal year ending in April, not a specific date range.
Date = CALENDAR(2015, 02, 01, 2030, 12, 31) is incorrect. CALENDAR requires DATE functions for start and end dates, not unformatted numbers.
Date = CALENDARAUTO() is incorrect. CALENDARAUTO() creates a date table based on available dates, not a custom date range.