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