Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

if value does not equal

I have two columns where i need to find if [Assigned To] is not match [#"Position closed/Ref by"] then give me [#"Position closed/Ref by"] and rest give me [Assigned To] values

 

i tried this 

 

if [Assigned To] <> [#"Position closed/Ref by"]  then [#"Position closed/Ref by"] else [Assigned To]

Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , what is the issue ?

     

    this should work in power query

    if [Assigned To] <> [#"Position closed/Ref by"] then [#"Position closed/Ref by"] else [Assigned To]

     

    and in dax

    if ([Assigned To] <> [#"Position closed/Ref by"] ,[#"Position closed/Ref by"] ,[Assigned To] )

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , what is the issue ?

     

    this should work in power query

    if [Assigned To] <> [#"Position closed/Ref by"] then [#"Position closed/Ref by"] else [Assigned To]

     

    and in dax

    if ([Assigned To] <> [#"Position closed/Ref by"] ,[#"Position closed/Ref by"] ,[Assigned To] )