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-10-22", "2",

                                     If( date between "2022-10-23" and "2022-10-26", "3", "null")))

 

and returns the results: 

DateStatus
15/10/20221
16/10/20221
17/10/20221
18/10/20221
19/10/20222
20/10/20222
21/10/20222
22/10/20222
23/10/20223
24/10/20223
25/10/20223
26/10/20223

 

Someone can help me?

 

Thanks a lot!

Need a help
  • lukiz84's avatar
    lukiz84
    3 years ago
    Status = If( date >= DATEVALUE("2022-10-15") && date <= DATEVALUE("2022-10-18"), "1",
...

6 Replies

  • lukiz84's avatar
    lukiz84
    Memorable Member
    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 Anonymous ,

    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.

    • lukiz84's avatar
      lukiz84
      Memorable Member
      3 years ago

      This won't work for a calculated column and is a time intelligence function to get a table of dates which are between start and end date.

  • 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.

  • 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
)