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,