Exam PL-300 topic 2 question 36 discussion

HOTSPOT -
You are building a financial report by using Power BI.
You have a table named financials that contains a column named Date and a column named Sales.
You need to create a measure that calculates the relative change in sales as compared to the previous quarter.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Suggested Answer:
Box 1: CALCULATE -
Calculate the sum.

Box 2: DATEADD -
DATEADD -1 QUARTER will give the previous month.

Box 3: DIVIDE -
Use DIVIDE to get the relative change.