Microsoft Certified: Power BI Data Analyst Associate PL-300 Question # 32 Topic 4 Discussion

PL-300 Exam Topic 4 Question 32 Discussion:

Question #: 32

Topic #: 4

Which DAX expression should you use to get the ending balances in the balance sheet reports?

CALCULATE (

SUM( BalanceSheet [BalanceAmount] ),

DATESQTD( 'Date'[Date] )

)

CALCULATE (

SUM( BalanceSheet [BalanceAmount] ),

LASTDATE( 'Date'[Date] )

)

FIRSTNONBLANK ( 'Date' [Date]

SUM( BalanceSheet[BalanceAmount] )

)

CALCULATE (

MAX( BalanceSheet[BalanceAmount] ),

LASTDATE( 'Date' [Date] )

)

Get Premium PL-300 Questions

Actual exam question for Microsoft PL-300 exam by Nyx89319 at Apr 29, 2026, 9:14:12 PM

Chosen Answer: A B C D
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.