Exam PL-300 topic 3 question 105 discussion

Actual exam question from Microsoft's PL-300

Question #: 105
Topic #: 3

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?

A. MOVINGAVERAGE([Sales], 4)
B. RUNNINGSUM([Year])
C. CALCULATE ( [Sales], 'Date' [Year] <= MAX ( 'Date'[Year] ) )
D. RUNNINGSUM([Sales])

Show Suggested Answer

Suggested Answer: C 🗳️

by bp_a_user at June 11, 2025, 8:48 p.m.

Comments

Submit Cancel

Lulu_2022

1 month ago

Selected Answer: C

Why this works: This DAX expression creates a cumulative total by summing the current year’s sales plus all previous years — exactly what the question asks for. MAX('Date'[Year]) returns the current year in the filter context. 'Date'[Year] <= MAX('Date'[Year]) filters the table to include the current year and all earlier years. CALCULATE([Sales], ...) then evaluates the total sales over that filtered set. This is a classic running total pattern in DAX.

upvoted 1 times

...