Forum Discussion
Use relative date to exclude current year
Hi, I need to get all years of data prior to this year. Can I do this through the Relative Date filter?
Thanks,
Hi,
No, you can only be static with the range of years you need.
Create a calculated column instead and put it in filter pane =1
FlagColumn = IF(YEAR('YourTable'[DateColumn]) < YEAR(TODAY()), 1, 0)
1 Reply
- Kaviraj11
Solution Sage
Hi,
No, you can only be static with the range of years you need.
Create a calculated column instead and put it in filter pane =1
FlagColumn = IF(YEAR('YourTable'[DateColumn]) < YEAR(TODAY()), 1, 0)