cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vinicius_ramos
Helper III
Helper III

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!

1 ACCEPTED SOLUTION
lukiz84
Solution Sage
Solution Sage

Status = If( date >= DATEVALUE("2022-10-15") && date <= DATEVALUE("2022-10-18"), "1",
...

View solution in original post

6 REPLIES 6
tamerj1
Super User
Super User

HI @vinicius_ramos 
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
)
NikhilChenna
Continued Contributor
Continued Contributor

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.

NikhilChenna
Continued Contributor
Continued Contributor

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.

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.

lukiz84
Solution Sage
Solution Sage

Status = If( date >= DATEVALUE("2022-10-15") && date <= DATEVALUE("2022-10-18"), "1",
...

@lukiz84 

 

Thanks a lot.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors