How do you add a Fiscal Year Column to a date table

Hi Anonymous ,

Thanks for sharing lbendlin , you can also try Ashish_Mathur 's formula.

I have also create a simple sample, please refer to.

Create a column.

Fiscal Year =
VAR CurrentDate = 'Table'[Date]
VAR FiscalStartMonth = 6
RETURN
    IF (
        MONTH ( CurrentDate ) >= FiscalStartMonth,
        YEAR ( CurrentDate ) & "/"
            & YEAR ( CurrentDate ) + 1,
        YEAR ( CurrentDate ) - 1 & "/"
            & YEAR ( CurrentDate )
    )

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.