Converting Excel IF/OR/AND statement to DAX

[wbarnes]

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!!

[jewel_at]

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]

Thank you for your suggestion, this works!

[adudani · Accepted solution]

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]

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

I ended up following your layout.