DAX: Standard Calendar YTD
YTD Total =
// Get latest complete month
VAR _YtD = MAX( Dates[LatestMTD] )
// Calculation
VAR _Total = CALCULATE(
[Measure],
Dates[Date] <= _YtD
)
RETURN
-- Measure returns cumulative total (inc. grand total)
_Total
Commentaires