Forum Discussion

smashbroski's avatar
smashbroski
Regular Visitor
6 years ago
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...
Need Help
Show and Tell
  • smashbroski's avatar
    smashbroski
    6 years ago

    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!

smashbroski's avatar
smashbroski
Regular Visitor
6 years ago

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!