Only show data in visualisation if financial year is within the next 25 years

[siddrow]

Hi

I've got a financial year column in my dataset which I'm using in the Timeline Storyteller visualisation. I need to only filter on years within the next 25 years only (my dataset goes up to 2070). The format of the financial year is "2022" so i'm struggling to work out how to do this. It will need to be a rolling automatic calculation, so for FY 2023, it will show data for 2023-2048, then next financial year it will show data for 2024-2049. I don't want to have to add in a new custom column or filter every new FY.

thanks in advance.

[amitchandak · Accepted solution]

@siddrow . If you year start on 4 month then you need measure like

Measure =

Var _min = if(month(today()) <4, year(toady()) , year(toady()) +1 )

var _max = _min +25 

var _min1 = date(_min, 4,1)

var _max1 = date(_max,3,31)

return

calculate(sum(Table[Value]), filter(Table , Table[Date] >=_min1 && (Table[Date]) <=_max1))

Starting from next FY