Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Date Calculation

Hello,    I need to do a something like "IF" with dates, for example:    Status = If( date between "2022-10-15" and "2022-10-18", "1",                     If( date between "2022-10-19" and "2022...
Need a help
  • lukiz84's avatar
    lukiz84
    3 years ago
    Status = If( date >= DATEVALUE("2022-10-15") && date <= DATEVALUE("2022-10-18"), "1",
...
tamerj1's avatar
tamerj1
Community Champion
3 years ago

HI Anonymous 
Please try

Status =
SWITCH (
    TRUE (),
    'Table'[Date] >= DATE ( 2022, 10, 15 )
        && 'Table'[Date] >= DATE ( 2022, 10, 18 ), 1,
    'Table'[Date] >= DATE ( 2022, 10, 19 )
        && 'Table'[Date] >= DATE ( 2022, 10, 22 ), 2,
    'Table'[Date] >= DATE ( 2022, 10, 23 )
        && 'Table'[Date] >= DATE ( 2022, 10, 26 ), 3
)