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: