topic Re: Replicate IF Formula in DAX in DAX Commands and Tips

Replicate IF Formula in DAX

Anonymous — Sun, 22 Sep 2019 01:03:42 GMT

Based on screenshot below, I need the following logic to be replicated in DAX:

IF(Job_Booking_DateTime < 12 midday, IF(hour of Job_Booking_DateTime + hours in Acceptance_Elapsed_Time <24), "Y","N"),"N")

Appreciate any help, thanks.

Anonymous — Sun, 22 Sep 2019 01:07:18 GMT

I forgot to mention to exclude weekends in the formula i.e. Saturday and Sunday

Nathaniel_C — Sun, 22 Sep 2019 02:48:25 GMT

Hi Anonymous ,

Try this.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

IF(Hour(Job_Booking_DateTime) < 12,

IF(Hour(Job_Booking_DateTime) + Hour(Acceptance_Elapsed_Time ) <24,

"Y","N"),"N")

Nathaniel_C — Sun, 22 Sep 2019 02:50:24 GMT

Hi Anonymous ,

Which column would you like to use for the weekend specification.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Nathaniel_C — Sun, 22 Sep 2019 02:57:10 GMT

Hi Anonymous ,

Wrap this around the above formula, and fill in the date.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

If (WEEKDAY(Date, 2) = 6 || WEEKDAY(Date,2) = 7, “”,The formula applied above)

Anonymous — Sun, 22 Sep 2019 04:46:18 GMT

Nathaniel_C thank you but there some blanks in Acceptance_DateTime column so how do I include IF Blank(), return " "?

Anonymous — Sun, 22 Sep 2019 06:27:42 GMT

Nathaniel_C its ok I fixed it. Thank you again for you help, appreciate it.

Nathaniel_C — Sun, 22 Sep 2019 12:26:26 GMT

Hi Anonymous ,

If this solves your problem, please mark it as a solution so that others may find it more quickly!

Thank you,

Nathaniel