Replicate IF Formula in DAX

[Anonymous]

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

Here is sample data file

Appreciate any help, thanks.

[Nathaniel_C]

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]

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]

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]

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

[Anonymous]

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

[Nathaniel_C · Accepted solution]

Hi @Anonymous ,

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

Thank you,

Nathaniel

[Anonymous]

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