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.


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)
  1. Function: PastYear(YTDSum([Total measure]))*
  2. 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