This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Cookie Policy. Click Preferences to customize your cookie settings.
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
