DP-500 Question #111: Real Exam Question with Answer & Explanation

Question

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

Explanation

This question tests your ability to write a DAX measure that computes quarter-over-quarter (QoQ) relative sales change using time intelligence functions in Power BI.

Approach. The correct measure uses CALCULATE with SUM('financials'[Sales]) to get current quarter sales, then uses CALCULATE with SUM('financials'[Sales]) wrapped in PREVIOUSQUARTER('financials'[Date]) to get the prior quarter sales. The relative change is then computed as (CurrentQtrSales - PreviousQtrSales) / PreviousQtrSales. A complete example: QoQ Sales Change % = DIVIDE(SUM('financials'[Sales]) - CALCULATE(SUM('financials'[Sales]), PREVIOUSQUARTER('financials'[Date])), CALCULATE(SUM('financials'[Sales]), PREVIOUSQUARTER('financials'[Date]))), which safely handles division by zero.

Concept tested. DAX time intelligence functions - specifically PREVIOUSQUARTER() combined with CALCULATE() and DIVIDE() - to compute period-over-period relative change in Power BI.

Reference. Microsoft Learn: DAX time intelligence functions - https://learn.microsoft.com/en-us/dax/time-intelligence-functions-dax

No community discussion yet for this question.