Forum Discussion
Filter based on multiple columns
I have a Data table that looks like in the picture below. I have one column with unique IDs and one column with a text string. The text string contains different combinations of a code. I want to be able to filter the table based on if one (or several) of the codes contains in the text string.
I have manually created new conditional columns for each code.
Is there a way to have a simple “filter table” connected to the Data Table and filter the Data Table with this filter table? How do I do this?
Grateful for help!
Anonymous , if you have only the first two columns. My advice would split the second column into rows in power query
Split Column Power Query: https://youtu.be/FyO9Vmhcfag
2 Replies
- amitchandakSuper User
Anonymous , if you have only the first two columns. My advice would split the second column into rows in power query
Split Column Power Query: https://youtu.be/FyO9Vmhcfag
- AnonymousNot applicable
Thank you so much! That works perfectly!