TOTALYTD Evaluates the year-to-date value of the expression in the current context.




Expression – An expression that returns a scalar value.

Dates – A column that contains dates.

Filter – (optional) An expression that specifies a filter to apply to the current context.

Year_end_date – (optional) A literal string with a date that defines the year-end date. The default is December 31.

Return Value

A scalar value that represents the expression evaluated for the current year-to-date dates.

Reference Data

DAX Functions / Time Intelligence Functions / TOTALYTD