BenchMark Quizzes by MDFT Pro

Create Date Table For Custom Date Range With DAX

MDFT Pro 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.

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.

Learn more about CALENDAR in Power BI:

The CALENDAR Function

Exam Preparation Quiz

Create Date Table For Custom Date Range With DAX