Forum Discussion
Relative date filtering, need last 3 years PLUS YTD.
I know this is an old thread but putting this on anyways.
This 'Should' be something relative date could do but sadly doesn't. I created a calculated field on my date table called YearIndex
So the current year is 0 and the prior year is -1. Now you can just use the basic filter to get Current Year and Last year or however many years you want.YearIndex =VAR ThisYear = YEAR(NOW())RETURNDates[Year] - ThisYear
Community ChampionAnonymous- The relative date slicer doesn't work that way. You can do Last x Years (current date to current date) or Last x Years (Calendar) but not what you are asking. Therefore, you are going to have to change the filter context of your visual(s). Easiest thing to do would be to use Year (Calendar) mode and then just wipe out anything that is greater than TODAY().
dbhudiaAdvocate I
I know this is an old thread but putting this on anyways.
This 'Should' be something relative date could do but sadly doesn't. I created a calculated field on my date table called YearIndex
So the current year is 0 and the prior year is -1. Now you can just use the basic filter to get Current Year and Last year or however many years you want.YearIndex =VAR ThisYear = YEAR(NOW())RETURNDates[Year] - ThisYearThank you! Solved my issue, exactly what I was looking for. Should be chosen as solution.
I logged in, just to be able to give you a thumbs up! Your solution is perfect for me.
Amazing Solution! Thank you!
