if value does not equal

[Anonymous]

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]

[amitchandak · Accepted solution]

@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] )