Dynamic timetable

Hi paolomint ,

Don't know how you have your timetable setup and if it's DAX or M language, however and depending on the way you want to do have the data you can do it in several manners.

• If you want to have all you data in the model and "force" people to see the last 3 years you can add a filter to the report with that:

• Another way is to create a column on your calendar table similar to this one and use this column to filter out the data you need in the report filter.

Analisys Date = IF( Year(Calendar[Date]) >= Year(Today) - 2 && Year(Calendar[Date]) <= Year(Today) ), 1)

• Other option is to change your calendar table adding the following:

DAX CALENDAR TABLE=
FILTER (
    CALENDAR ( "01/01/2012", "31/12/2025" ),
    YEAR ( [Date] )
        >= YEAR ( TODAY () ) - 2
        && YEAR ( [Date] ) <= YEAR ( TODAY () )
)

The filter expression should wrap your calendar syntax

If on the query editor go to your date column and add a filter with the following syntax:

= Table.SelectRows(#"Changed Type2", each Date.IsInPreviousNYears([Date], 2) or Date.IsInCurrentYear([Date]))