Exam PL-300 topic 2 question 74 discussion

Agreed with SUMMARIZE - Date[Year]

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] )

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)

I think it should be.. Summarize , sales [date]

How this can be correct if Date[Year] is integer?

Ans is correct

Agreed