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 , 

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

    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'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 " "?