Skip to main content
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Not applicable

calculated Fiscal year Date Time table issue



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:
data model.png
Fiscal year is from 4/1- 3/31
Market Year is from 10/1- 9/30
Date table
current date table.png
Community Support
Community Support

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

Helpful resources

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors