Home » Microsoft » PL-300 » How should you complete the measure?
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:
Correct Answer:
Explanation/Reference:
Explanation:
Box 1: CALCULATE
Box 2: DATEADD
Box 3: DIVIDE
Example:
NET_SALES QoQ% =
IF(
ISFILTERED(‘Calendar'[Date]),
ERROR(“Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column.”), VAR __PREV_QUARTER = CALCULATE( SUM(‘research ra_qtr_template'[NET_SALES]), DATEADD(‘Calendar'[Date].[Date], -1, QUARTER) ) RETURN DIVIDE( SUM(‘research ra_qtr_template'[NET_SALES]) – __PREV_QUARTER, __PREV_QUARTER ))
Reference:
https://community.powerbi.com/t5/Desktop/Error-calculating-QOQ-using-quick-measure/mp/547054