YTD function reference
Below gives a solution on how to compare this year results up to today with previous year until the same parallel day.
Solution:
If you want to compare this year and the previous year you can add a widget filter where you will choose the current day (or a specific day)
- Function: PastYear(YTDSum([Total measure]))*
- Widget filter-today (keep in mind if you do not have value for today you will not get results)
- If you want to compare to 2 years ago (YTD), use the Past year function again and wrap the entire function
Updated 03-02-2023
