I have an income table joined to a date table. I want to build a matrix that shows the total income to todays date and then also the total income for the same period last year.
My income to todays date is a simple TOTALYTD calculation and it works fine. It shows the total income from 01/01/2021 to 17/05/2021 (i.e. today). However, my TOTALYTD for last year uses SAMEPERIODLASTYEAR but shows the income from the whole year, i.e. 2020. It does not just show 01/01/2020 to 17/05/2020. I understand that if I applied a filter to my matrix to restrict the income date to 01/01/2021 to todays date then the YTD-1 would show the correct period last year, but is there a way of getting the matrix to automatically restrict the YTD-1 to only go up to todays date, last year?
