Forum Discussion
Solved
Cyclic Reference Error When Checking Whether Row Value in Column B Exists in Column A in Power Query
Hello, I have a table with an _id column and a parent_capability_id column both with values of type text. I am trying to create a custom column that returns 1 if the value in the parent_capabili...
d_pbi_2 , Use the last step table name, say it #"change type"
if List.Contains(#"change type"[_id], [parent_capability_id]) then 1 else null
List.Contains and List.ContainsAll: https://youtu.be/oiLTUC1RCbU
d_pbi_2 , Use the last step table name, say it #"change type"
if List.Contains(#"change type"[_id], [parent_capability_id]) then 1 else null
List.Contains and List.ContainsAll: https://youtu.be/oiLTUC1RCbU
That did the trick! Thank you amitchandak!