Filter page by column value

[IvanDP]

Good morning,

is there anyway that I can set a page level filter to a report and use a column as a part of the filter.

I'm trying to filter by year dinamically, so this year I'll have year 2020, 2021 and 2022 but next year I would like to have 2021, 2022 and 2023 without changing the filter every time

thanks for your help

[amitchandak]

@IvanDP , You need create a column like this you date table/table

Switch(True() ,

[Year] >= year(Today()) -2 && [Year]  >= year(Today())  ,  "Last three year"

[Year]

)

You can save page on last three year

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA