calculated Fiscal year Date Time table issue

Hi,

I am facing an issue with my Fiscal year calculation on my date time table. The issue has caused filtering between FY23 and FY22 and FY21 to not work properly. 

This is also affecting the MY23 and MY22 and MY21 filtering. 

The current FY DAX calculated column in the date table.

IF('Market Year Dates'[Current Month]<=3,'Market Year Dates'[Current Year]-1,'Market Year Dates'[Current Year])

 

The result is that new data flows into this query but the previous year data is not showing up. 

 

There is something wrong with this DAX formula that is affecting the users ability to check the prior years data. 

 

 

Here is the data model:

 

 

Fiscal year is from 4/1- 3/31

Market Year is from 10/1- 9/30

 

Date table

 

 

Gratzi