Your company, MDFT Academy, requires a fiscal year that starts in May. You need to create a common date table for your data model using DAX so that all reports align with the fiscal calendar.
How should you complete the DAX expression to create a fiscal year date table starting in May?
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 = CALENDARAUTO(4) is correct. CALENDARAUTO(4) creates a date table with the fiscal year starting in May and ending in April.
Date = CALENDAR(DATE(2025, 05, 01), DATE(2027, 04, 30)) is incorrect. CALENDAR creates a date table for a specific range, but does not define May as the first month of the fiscal year.
Date = CALENDARAUTO() is incorrect. CALENDARAUTO() creates a date table based on available dates, but does not set a custom fiscal year.
Date = CALENDAR(DATE(2025, 01, 01), DATE(2021, 12, 31)) is incorrect. This creates a date table for a calendar year, not a fiscal year starting in May.