This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules. However, it is recommended you specify year_end_date using 'month/day' (as shown) to ensure the string resolves to a date. In this example, year_end_date can be specified as '6/30', 'Jun 30', '30 June', or any string that resolves to a month/day.

= TOTALYTD(SUM(InternetSales_USD),DateTime, ALL('DateTime'), '6/30') For example, the following formula specifies a (fiscal) year_end_date of 6/30 in an EN-US locale workbook. The year portion of the date is not required and is ignored. The year_end_date parameter is a string literal of a date, in the same locale as the locale of the client where the workbook was created. The filter expression has restrictions described in the topic, CALCULATE.

A Boolean expression that defines a single-column table of date/time values.Ĭonstraints on Boolean expressions are described in the topic, CALCULATE.

A table expression that returns a single column of date/time values.

The dates argument can be any of the following: The default is December 31.Ī scalar value that represents the expression evaluated for the current year-to-date dates. (optional) A literal string with a date that defines the year-end date. (optional) An expression that specifies a filter to apply to the current context.

Syntax TOTALYTD(,)Īn expression that returns a scalar value. Evaluates the year-to-date value of the expression in the current context.

Ytd full version