Calculates week-to-date results for an expression. Week functions like this one need calendar-based time intelligence.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains TOTALWTD in context, with comparison tables and the common traps.
Terms in this definition
- LIKE
Compares strings with a pattern that can contain the % and _ wildcards. Because it only understands character patterns, searching big volumes of text this way is much slower than using full-text search.
- Calendar-based time intelligence
A preview approach to DAX date maths: after switching on Enhanced DAX Time Intelligence, you set up calendars on a table through Calendar options and pass those, rather than a date column, to time functions. Fiscal, retail and week-based calendars are all handled.