Forum Discussion
True or False when value from column A is present in Column B
Hello everyone, I have a column that shows two different informations. I would like to create a custom column where it will return a True/False if a value in Column A (Component) appears in Col...
Hi Anonymous
You can add a custom column with below code. Notice that you need to modify "Previous Step" accordingly. For example, "Changed Type" is the previous step in my example, so I used it as shown in below image. If you want to add it after "Added Conditional Column" step, you should use "Added Conditional Column" instead.
List.Contains(#"Previous Step"[Immediate Parent],[Component])Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
wdx223_Daniel
Community Champion
Community ChampionNewStep=let a=List.Buffer(PreviousStepName[Immediate Parent]) in Table.AddColumn(PreviousStepName,"Custom",each List.Contains(a,[Component]))