You have a Power BI model that contains a table named Date. The Date table contains the following columns:
• Date
• Fiscal Year
• Fiscal Quarter
• Month Name
• Calendar Year
• Week Number
• Month Number
• Calendar Quarter
You need to create a calculated table based on the Date table. The calculated table must contain only unique combinations of values for Calendar Year, Calendar Quarter, and Calendar Month.
Which DAX function should you include in the table definition?

A. ADDCOLUMNS

B. CALCULATE

C. SUMMARIZE

D. DATATABLE








 

Suggested Answer: A



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