Forum Discussion
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 ...
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] )
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] )