topic Re: Date Calculation in DAX Commands and Tips

Date Calculation

Anonymous — Tue, 29 Nov 2022 15:16:54 GMT

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:

Date	Status
15/10/2022	1
16/10/2022	1
17/10/2022	1
18/10/2022	1
19/10/2022	2
20/10/2022	2
21/10/2022	2
22/10/2022	2
23/10/2022	3
24/10/2022	3
25/10/2022	3
26/10/2022	3

Someone can help me?

Thanks a lot!

Re: Date Calculation

lukiz84 — Tue, 29 Nov 2022 15:22:09 GMT

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

Re: Date Calculation

NikhilChenna — Tue, 29 Nov 2022 15:31:08 GMT

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.

Re: Date Calculation

lukiz84 — Tue, 29 Nov 2022 15:28:59 GMT

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.

Re: Date Calculation

NikhilChenna — Tue, 29 Nov 2022 15:31:46 GMT

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 =

this will solve your issue.

Regards,

Nikhil Chenna

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

Re: Date Calculation

tamerj1 — Tue, 29 Nov 2022 16:10:20 GMT

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 )

Re: Date Calculation

Anonymous — Wed, 30 Nov 2022 22:01:36 GMT

lukiz84

Thanks a lot.