PL-300 Question #495: Real Exam Question with Answer & Explanation

Question

You have a Power BI report that contains a clustered bar chart. The chart has an X-axis named Sales and a Y-axis named Year. The chart displays sales data for the years 2020 through 2024. You need to create a visual calculation to show a cumulative total of sales that is equal to the sum of the current year's sales plus all the sales from the previous year. Which DAX expression should you use? MOVINGAVERAGE([Sales], 4) A.

Options

• BRUNNINGSUM([Year])
• CCALCULATE ( [Sales], 'Date' [Year] <= MAX ( 'Date'[Year] ) )
• DRUNNINGSUM([Sales])

Explanation

The answer key identifies A (MOVINGAVERAGE([Sales], 4)) as correct. However, the question description - 'cumulative total equal to the current year plus all previous years' - semantically describes a running sum, which is exactly what RUNNINGSUM([Sales]) (option D) computes. MOVINGAVERAGE([Sales], 4) calculates the average of the current period and the 3 preceding periods, which is not a cumulative total. RUNNINGSUM([Year]) (B) applies the running sum to the Year axis rather than the Sales measure, which is meaningless. The CALCULATE expression in C replicates a traditional running total but is not a visual calculation function. This question appears to contain an error in either the question text or the answer key; based on the description given, D (RUNNINGSUM([Sales])) is the logically correct answer for a true cumulative total.

No community discussion yet for this question.