BenchMark Quizzes by MDFT Pro

Create Fiscal Year Date Table With DAX

Your company, MDFT Pro, 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.

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.

Learn more about CALENDARAUTO in Power BI:

The CALENDARAUTO Function

Exam Preparation Quiz

Create Fiscal Year Date Table With DAX