BenchMark Quizzes by MDFT Pro

Understand Auto Date/Time And Date Hierarchies In Power BI

You create a dataset using Power BI Desktop for MDFT Academy. Your source data contains many columns with dates, including a column for marketing campaign end dates where users enter December 31, 2999 if there is no end date. The Auto date/time option is enabled.

How does the Auto date/time feature affect your dataset and what should you consider when working with date hierarchies?

Choose the correct answer from the options below.

Explanations for each answer:

Date hierarchies are automatically created for all date columns in the dataset with Day/Week/Month/Year filters. is incorrect. Date hierarchies are created for Day/Month/Quarter/Year, but not for Weeks. Week filters are not included by default.
The size of the dataset can be reduced by disabling the Auto date/time option. is correct. Disabling Auto date/time removes hidden calculated date tables, reducing dataset size.
The automatically created date hierarchies can be configured to begin for any month in the year. is incorrect. Auto date/time hierarchies cannot be configured to start on a different month; they always use calendar years.
Auto date/time hierarchies are visible in the Fields pane as separate tables. is incorrect. Auto-generated date/time hierarchy tables are hidden and not visible in the Fields pane by default. Only the collapsible date/time hierarchy itself is visible.

Learn more about Auto date/time in Power BI:

Power BI Date Hierarchies

Exam Preparation Quiz

Understand Auto Date/Time And Date Hierarchies In Power BI