TOTALYTD DAX Function

The TOTALYTD function is used to calculate a cumulative total year-to-date value for a given expression in the current filter context. It considers the dates from the start of the year up to the specified date.

DAX Syntax TOTALYTD(expression, dates[,filter][,year_end_date])

Example: Click on New measure. The following expression creates a measure.

DAX

The TotalYTD function = TOTALYTD(SUM(Sheet8[Annual Income]),'Sheet8'[Year])
TOTALYTD dax function

Here the end date is not specified, so by default it is 31st December.

TOTALYTD dax function
Previous Next