Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Calculated Column for Text Containing from another Column

Hello,   I am looking for a way to create a calculated column called "Matching" where it compares Column B against column A. The output I am looking for is column D.   I have tried doing Text.Co...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    Please try this custom column in Power Query.

    = if List.Contains(Text.Split([App Approvers], ", "), [Approver]) then "True" else "False"

    This formula uses the Text.Split function to split the values in Column App Approvers into a list, and then uses the List.Contains function to check if the value in Column Approver is in the list. If it is, the formula returns "True". If it isn't, the formula returns "False".

     

     

     

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

Please try this custom column in Power Query.

= if List.Contains(Text.Split([App Approvers], ", "), [Approver]) then "True" else "False"

This formula uses the Text.Split function to split the values in Column App Approvers into a list, and then uses the List.Contains function to check if the value in Column Approver is in the list. If it is, the formula returns "True". If it isn't, the formula returns "False".

 

 

 

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.