Microsoft Power BI Data Analyst — Question 22

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?

Answer options

• A. ADDCOLUMNS
• B. CALCULATE
• C. SUMMARIZE
• D. DATATABLE

Correct answer: C

Explanation

The correct answer is C (SUMMARIZE) because this function is specifically designed to create a summary table based on specified columns, ensuring unique combinations. ADDCOLUMNS adds new columns to an existing table, CALCULATE modifies filters on existing data, and DATATABLE creates a table with specified values but does not aggregate or ensure uniqueness.