Fiscal Year Filter

Hi Anonymous 

Thanks for your reply it works perfectly for me.

How can I achieve this for the fiscal year?

Thanks,

Hi  Shreeram04 ,

Do you mean FY22 when you say fiscal year?

Here are the steps you can follow：

1. Create calculated column.

Year = YEAR('Table'[Date])

FY Year =
"FY" &""&RIGHT('Table'[Year],2)

2. Create calculated table.

Year =
DISTINCT('Table'[FY Year])

3. Create measure.

Flag =
var _select=
SELECTEDVALUE('Year'[FY Year])
var _year=MAXX(FILTER(ALL('Table'),'Table'[FY Year]=_select),[Year])
return
IF(
    MAX('Table'[Year]) <=_year,1,0)

4. Place [Flag]in Filters, set is=1, apply filter.

5. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly