Home » Microsoft » DA-100 » 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] ) )
Correct Answer: A
Explanation/Reference:
Scenario: At least one of the balance sheet reports in the quarterly reporting package must show the ending balances for the quarter, as well as for the previous quarter.
DATESQTD returns a table that contains a column of the dates for the quarter to date, in the current context.
Reference: https://docs.microsoft.com/en-us/dax/datesqtd-function-dax