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
Explanation: 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