Forum Discussion
Solved
IF(AND( Function comes back with Expression.Error
Hello Everyone, I'm trying to do an IF (AND( DAX command within PowerBI and when I create a custom column and type the following it comes back with no errors. But when I apply it, it...
Hi affan
That didn't resolve the issue so I did some searching and the following worked for me
= Table.AddColumn(#"Removed Duplicates2", "SLM Justification", each if [SLM Status] = "Service Targets Breached" and [Last Resolved Date]<[#"Due Date/Time"] then "Justified" else null)
Found it kinda funny becuase I think I typed that a million times and it came back with errors.
Thanks for you help!
That's because you are entering DAX when you should be using M...you shouldn't do that...