Exam4Training

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

Latest PL-300 Dumps Valid Version with 131 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version