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
Step Sequence / Reordering Question
Add and arrange the steps in the correct execution order.
Hotspot Solution:
I've recreated mock data through ChatGPT and in PowerBI. I've tested the following dax measure : - SalesSummary = SUMMARIZE(Sales,Date[Date],"Sales",SUM(Sales[Sales])) - SalesSummary = SUMMARIZE(Sales,Date[Year],"Sales",SUM(Sales[Sales])) First dax measures creates a table that has many rows as many sales in that month have been sold and does not respond to "A row for each year" requirement. By using Date[Year], you have a summarized Table which you have ONLY one row per each year with the value as sum Something like this : 2024 | 8000,00$ 2023 | 5000,00$ Rollup and Select Columns in first menu are wrong as they don't match parameters. So, Correct answer is SalesSummary = SUMMARIZE(Sales,Date[Year],"Sales",SUM(Sales[SalesAmount])) (don't mind the names used for mockup data)
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
* Answer: 1. SUMMARIZE 2. Date[Year] * Explanation; - SUMMARIZE: Creates a table grouped by the specified columns (Date[Year]). - Because the Date table is related to Sales by the Date column, the aggregation works correctly.
The ROLLUP function is used exclusively within SUMMARIZE. E.g. SUMMARIZE ( Sales, ROLLUP ( 'Date'[Calendar Year] ), "Year total", ISSUBTOTAL ( 'Date'[Calendar Year] ), "Amount", [Sales Amount] )
Correct answer -> SUMMARIZE, Date[Year]