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

Which DAX expression should you use to get the ending balances in the balance sheet reports?
A. CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), DATESQTD( ‘Date'[Date] ) )
B. CALCULATE ( SUM( BalanceSheet [BalanceAmount] ), LASTDATE( ‘Date'[Date] ) )
C. FIRSTNONBLANK ( ‘Date’ [Date] SUM( BalanceSheet[BalanceAmount] ) )
D. CALCULATE ( MAX( BalanceSheet[BalanceAmount] ), LASTDATE( ‘Date’ [Date] ) )

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.