Exam PL-300 topic 2 question 73 discussion

I wanna say that again. Comment and vote carefully before you have actually done some research otherwise It will cause confusion to other people. The answer is Summarize. UniqueCalendarTable = SUMMARIZE( Date, 'Date'[Calendar Year], 'Date'[Calendar Quarter], 'Date'[Month Name] )

Should be Summarized

I think for me the answer is A- Addcolumns . In this context we have Calendar Year, Calendar Quarter listed in the Date table but we don't have Calendar Month in the Date table. The question require a calculated table with all Calendars (Year, Month, Quarter) so we can use both function: Summarize and Addcollumns ( Why? because of a new column that is "Calendar Month" that we need to add in the required table) in Dax expression . So for the performance we also favour Addcolumns function. Where for me the answer is A- ADDCOLUMNS.

ADDCOLUMNS(<table>, <column name>, <expression>, [...]) would create a table with ADDITIONAL computed columns DATATABLE(<column names and types>, <data>) would create a table by explicitely defining rows and columns SUMMARIZE(<table>, <groupBy_columnName>, [...], [<name>, <expression>]...) would perform a GROUP BY operation, aggregating data based on specified columns and optional expressions

Thank you for your solution, Pocu, it helped a lot!

Summarize is the correct answer!

Should be Summarized

AddColumns creates a new table including ALL FIELDS from the selected table AND ADD new columns to it based on parameters Summarize creates a new EMPTY table using the table name given as first parameter and including the fields parameters that Intellisense is giving you SUMMARIZE is the function to use

It must be C not A

A is the correct answer I have tested.

https://youtu.be/VurpXBcbrT0

ADDCOLUMNS is correct. It Adds calculated columns to the given table or table expression whereas SUMMARIZE Returns a summary table for the requested totals over a set of groups.

The DATATABLE function in DAX allows you to create a calculated table. The calculated table can be based on any data source, including the Date table. To create a calculated table that contains only unique combinations of values for Calendar Year, Calendar Quarter, and Calendar Month, you can use the following DAX code:

Addcolumns does not create a new table, but Summarize does create it

SUMMARIZE should be the answer

I think it should be SUMMARIZE SUMMARIZE: "Creates a summary of the input table grouped by the specified columns." ADDCOLUMNS: "Returns a table with new columns specified by the DAX expressions." Based on this, using SUMMARIZE will give us the unique combination we want and don't need to use DAX expressions to create the calculated table.

The correct answer should be SUMMARIZE