Standard YTD
- Imran Haq
- Sep 27, 2021
- 1 min read
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 
Comentários