Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!!
Solved! Go to Solution.
Hi @wbarnes ,
Create the following calculated column using DAX.
Appreciate a thumbs up if you found this helpful.
Please accept this solution if the query is resolved.
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
Thank you for your suggestion, this works!
Hi @wbarnes ,
Create the following calculated column using DAX.
Appreciate a thumbs up if you found this helpful.
Please accept this solution if the query is resolved.
Both solutions worked, thank you so much for your help!
I ended up following your layout.
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |