Home » Microsoft » DA-100 v.2 » Which type of calculation and which formula should you use?
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: B
Explanation/Reference:
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.
Semi-additive calculations, such as balance at end of month, use LASTDATE Functions.
Reference:
https://docs.microsoft.com/en-us/learn/modules/create-measures-dax-power-bi/5-semi-additive-measures