You need to design the data model to meet the report requirements.
What should you do in Power BI Desktop?

A. From Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

B. From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

C. From Power BI Desktop, use the Auto date/time option when creating the reports.

D. From Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column.








 

Suggested Answer: C

On-Time Shipping report -
The On-Time Shipping report will show the following metrics for a selected shipping month or quarter:
The percentage of orders that were shipped late by country and shipping region
Customers that had multiple late shipments during the last quarter
The Auto date/time is a data load option in Power BI Desktop. The purpose of this option is to support convenient time intelligence reporting based on date columns loaded into a model. Specifically, it allows report authors using your data model to filter, group, and drill down by using calendar time periods (years, quarters, months, and days). What's important is that you don't need to explicitly develop these time intelligence capabilities.
When the option is enabled, Power BI Desktop creates a hidden auto date/time table for each date column, providing all of the following conditions are true:
The table storage mode is Import
The column data type is date or date/time
The column isn't the "many" side of a model relationship
Reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time

This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate







Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.