YTD and MTD over multiple years using the different Date functions

Owned by Clark Walliser
Last updated: Apr 05, 2023 by Cortlandt _
1 min read

There are multiple date functions you can use to calculate YTD and MTD values across years:
MAKEDATE, DATEADD, DATEDIFF, and DATETRUNC. And there are other ways to create YTD and MTD views without using these functions. The challenge is determining which method you want to use.

There are two ways to display YTD and MTD values across years:
YTD/MTD Calculation Filters, and YTD/MTD Calculated measures.

Each variation of functions and methods has its pros and cons, so it depends on the specific situation and the user’s preference on which method to use.

More about the various date functions and methods in action.

Â