calculated Fiscal year Date Time table issue

[Anonymous]

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 

[v-jialluo-msft]

Hi  @Anonymous ,

With your description, your requirement is to count the financial data based on the calculated columns created.

Upload sample files and expected output to further resolve the issue.

How to provide sample data in the Power BI Forum - Microsoft Power BI Community

Best Regards,
Gallen Luo