Conditional Column with values for fiscal year date ranges

Thag 

Table.AddColumn(TableName, "FiscalYearLabel", each 
         if [StartDate] >= #date(2023,9, 25  ) && [EndDate] <= #date(2024,9,24 ) then
            "FY1" else ""
    )

Incase if your financial year calculation invlolves any logic then please share it here to help you better.

For example if your financial year depends on current year then 

let
    Source = Excel.CurrentWorkbook(){[Name="YourTableName"]}[Content],
    

    FiscalStartFY1 = #date(2023, 9, 25),
    

    AddFY = Table.AddColumn(Source, "FiscalYearLabel", each 
        let
            CurrentDate = [YourDateColumn],
            FiscalYearNumber = Number.IntegerDivide(Duration.Days(CurrentDate - FiscalStartFY1), 365) + 1
        in
            "FY" & Text.From(FiscalYearNumber)
    )
in
    AddFY

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!