Forum Discussion
Filter page by column value
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
1 Reply
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
