TOTALYTD DAX Function in Power BI

The TOTALYTD DAX 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'[Date]  -- Must be a Date column
)

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

Previous Next