Forum Discussion
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...
rbowen Try:
FiscalYear = IF('Dates'[CalendarDate] >= DATE(2022,9,1) && 'Dates'[CalendarDate] <= DATE(2023,8,31), "2023", "2024")
rbowen Try:
FiscalYear = IF('Dates'[CalendarDate] >= DATE(2022,9,1) && 'Dates'[CalendarDate] <= DATE(2023,8,31), "2023", "2024")
That worked, thank you Greg!