Forum Discussion

wbarnes's avatar
wbarnes
Frequent Visitor
3 years ago
Solved

Converting Excel IF/OR/AND statement to DAX

I have been trying to convert the below Excel nested IF statement to DAX, and I cannot seem to get anything to work for me, maybe I'm making this more complicated than it really is. I'm new to DAX and can't seem to make the transition from Excel formulas to DAX!!!! Hoping someone can help me. 

Here is my Excel If statement:  =IF(OR(B2=0, B2=""), "Due Date Not Assigned", IF(AND(D2>=A2,D2<=B2),"Yes","No"))

Any help would be greatly appreciated!!

  • adudani's avatar
    adudani
    3 years ago

    Hi wbarnes ,

     

    Create the following calculated column using DAX.

     

    Completed by DueDate =
    IF( 'Table'[Due Date] = 0 || ISBLANK('Table'[Due Date]),
        "Due Date Not Assigned",
        IF( 'Table'[Completed Date]>= 'Table'[Assigned Date] && 'Table'[Completed Date]<= 'Table'[Due Date],"Yes","No"))
     
    There are more efficient ways to do this with switch true statements. However, this should get the job done.

     

    Appreciate a thumbs up if you found this helpful.

     

    Please accept this solution if the query is resolved.



4 Replies

  • adudani's avatar
    adudani
    Memorable Member
    3 years ago

    Hi wbarnes ,

     

    Create the following calculated column using DAX.

     

    Completed by DueDate =
    IF( 'Table'[Due Date] = 0 || ISBLANK('Table'[Due Date]),
        "Due Date Not Assigned",
        IF( 'Table'[Completed Date]>= 'Table'[Assigned Date] && 'Table'[Completed Date]<= 'Table'[Due Date],"Yes","No"))
     
    There are more efficient ways to do this with switch true statements. However, this should get the job done.

     

    Appreciate a thumbs up if you found this helpful.

     

    Please accept this solution if the query is resolved.



    • wbarnes's avatar
      wbarnes
      Frequent Visitor
      3 years ago

      Both solutions worked, thank you so much for your help!

      I ended up following your layout.

  • jewel_at's avatar
    jewel_at
    Resolver I
    3 years ago

     

    I think in DAX it will be something like this

     

    Column = 
IF('Table'[B] =0 || 'Table'[B] = null, "Due Date Not Assigned", IF('Table'[D] >='Table'[A] && 'Table'[D] <= 'Table'[B]',"Yes","No"))

     

     

    You can also just add a custom column that in Power Query

    if([B] = 0 or [B] = null) then "Due Date Not Assigned" else if([D] >= [A] and [D] <= [B]) then "Yes" else "No"

     

    Hope that helps! Let me know!

     

     

    Jewel

    • wbarnes's avatar
      wbarnes
      Frequent Visitor
      3 years ago

      Thank you for your suggestion, this works!