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

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
6 years ago

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

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

    • Nathaniel_C's avatar
      Nathaniel_C
      Icon for Community Champion rankCommunity Champion
      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