Forum Discussion

rbowen's avatar
rbowen
Icon for Helper III rankHelper III
2 years ago
Solved

Using Greater Than And Less Than With IF Statment

I'm trying to create a calculated column in my Date table for fiscal year based on the CalendarDate column. Here's what I'm after:   If the calendar date is greater than or equal 09/01/2022 and les...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    rbowen Try:

    FiscalYear = IF('Dates'[CalendarDate] >= DATE(2022,9,1) && 'Dates'[CalendarDate] <= DATE(2023,8,31), "2023", "2024")
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
2 years ago

rbowen Try:

FiscalYear = IF('Dates'[CalendarDate] >= DATE(2022,9,1) && 'Dates'[CalendarDate] <= DATE(2023,8,31), "2023", "2024")
  • rbowen's avatar
    rbowen
    Icon for Helper III rankHelper III
    2 years ago

    That worked, thank you Greg!