Exam PL-300 topic 2 question 74 discussion

Actual exam question from Microsoft's PL-300

Question #: 74
Topic #: 2

HOTSPOT
-

You have a Power BI model that contains the following data.

The Date table relates to the Sales table by using the Date columns.

You need to create a calculated table that will contain the following:

• A row for each year
• A column that contains the total sales per year

How should you complete the DAX calculation? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Show Suggested Answer

Suggested Answer:

by pverde at Aug. 5, 2023, 1:20 p.m.

Comments

Submit Cancel

pverde

Highly Voted 1 year, 9 months ago

Agreed with SUMMARIZE - Date[Year]

upvoted 30 times

...

1CY1

Most Recent 6 months, 3 weeks ago

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

upvoted 1 times

1CY1

6 months, 3 weeks ago

Correct answer -> SUMMARIZE, Date[Year]

upvoted 1 times

...

SomeAzureGuyincube

1 year, 1 month ago

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)

upvoted 4 times

...