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] ) )
Answer:A
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] ) )