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",
...
NikhilChenna's avatar
NikhilChenna
Skilled Sharer
3 years ago

Hi @vinicius_ramos ,

I have personally tried this and it worked out. 

 

You can achieve the above by creating a dax calculated column = 

 

Status_column =

IF( 'Date'[Date]>="2022-10-15"  &&  'Date'[Date]<="2022-10-18"), "1",
IF( 'Date'[Date]>="2022-10-19"  &&  'Date'[Date]<= "2022-10-19"), "2",
IF('Date'[Date]>= "2022-10-23" &&  'Date'[Date]<= "2022-10-26"), "3","null"
)))

 

this will solve your issue.

 

Regards,

Nikhil Chenna

 

Please apprecitate with Kudos, and accept this post as a solution if it works.