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

Microsoft PL-300 Question Answer

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] )

)

PL-300 PDF/Engine

Get 60% Discount on All Products, Use Coupon: "8w52ceb345"