Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Error
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
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,
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
