PdfPrep.com

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] )
)

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

Exit mobile version