Creating a lookup table to filter on a row that contains multiple names

[Anonymous]

Hey guys,

I have a dataset where multiple names can be assigned to an attribute. Those names are seperated by ";".

The goal is to create a filter where you can select "john" and it will show all data where "John" was in that cell, whether he was alone or with others.

Example of data:

John

John;Peter

Peter

Melissa

Peter;Melissa

Tom

John

Tom;Melissa

Any suggestions on how to do this? I'm thinking of a lookuptable but any solution is welcome. I'm sure that I'm not the first person to run into this problem! 🙂

Thanks!

[mwegener · Accepted solution]

Check this out. PBIX

Main Steps:

1. Duplicate the Column and Rename it

2. Split the Column by Delimiter

3. Advance option "Split into Rows"

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous]

Thanks. This is very helpful!