PL-300 · Question #363
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 Numb
The correct answer is C. SUMMARIZE. SUMMARIZE is the correct DAX function for generating a table of unique combinations of column values from an existing table. The syntax SUMMARIZE(Date, Date[Calendar Year], Date[Calendar Quarter], Date[Month Number]) returns exactly one row per distinct combination of those three
Question
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?
Options
- AADDCOLUMNS
- BCALCULATE
- CSUMMARIZE
- DDATATABLE
How the community answered
(47 responses)- A2% (1)
- B11% (5)
- C81% (38)
- D6% (3)
Explanation
SUMMARIZE is the correct DAX function for generating a table of unique combinations of column values from an existing table. The syntax SUMMARIZE(Date, Date[Calendar Year], Date[Calendar Quarter], Date[Month Number]) returns exactly one row per distinct combination of those three columns - which is the requirement. ADDCOLUMNS (A) adds new computed columns to an existing table but does not deduplicate rows. CALCULATE (B) modifies filter context for a scalar expression; it does not return a table of unique combinations. DATATABLE (D) creates a static, hardcoded inline table and cannot derive dynamic unique combinations from existing data.
Community Discussion
No community discussion yet for this question.