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!

affan's avatar
affan
Solution Sage
6 years ago

Hi smashbroski 

 

Please try the below DAX

 

IF([SLM Status]="Service Target Breached",
    IF([Last Resolved Date]<[#"Due Date/Time"], "Justified",null),null)

 

If this does not work please share your sample file.

 

If this helped you, please mark this post as an accepted solution and like to give KUDOS .

 

Regards,

Affan Farooqi