Error

Hi RichOB ,

 

If your goal is to create a calculated table that shows distinct financial years, here's the right approach:

FinancialYears = SUMMARIZE(
    'Calendar',
    FORMAT(EDATE('Calendar'[DATE], -3), "YYYY"),
    "Financial Year"
)

 

Best regards,

Hi RichOB ,

 

I think your problem has been solved from here: Solved: Re: DAX for Financial Year column - Microsoft Fabric Community

 

Best Regards,

Stephen Tao