Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Replicate IF Formula in DAX

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"),...
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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