Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Microsoft Certified: Power BI Data Analyst Associate · Microsoft
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
* Answer: C. SUMMARIZE - Returns a table with unique combinations of specified columns. Perfect for this requirement. * Why not the others: A. ADDCOLUMNS - Adds calculated columns to a table expression. It doesn’t remove duplicates or group by. B. CALCULATE - Changes filter context for measures. Not used to build a table of unique combinations. D. DATATABLE - Creates a static table by hardcoding values. Not dynamic, not based on the Date table.
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.
Just to correct myself I mean we always favour the ADDCOLUMNS before SUMMARIZE for a best performance.