top of page
Writer's pictureImran Haq

Standard YTD

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 



11 views0 comments

Recent Posts

See All

Commentaires


Post: Blog2_Post
bottom of page