Forum Discussion
Helper IIHow to filter a list based on select items in list?
I think you may need to shred the list of values where there is a single row for every Val1 value and each of its Column of Interest. values. Is there a "to rows" type function in Power Query that could do that? You may need to strip out noise words like "and" and spaces. Lord help you if someone does not use that annoying Oxford comma and puts "1, 2 and 3" instead of "1, 2, and 3"
If not, you can brute-force the T-SQL with a function that does it. Now your filter table is things like:
One, 1
One, 2
One, 3
etc,
Now, join that table to the fact table on a many-to-many join. Filter for Val1 and it should work.
Super UserI think you may need to shred the list of values where there is a single row for every Val1 value and each of its Column of Interest. values. Is there a "to rows" type function in Power Query that could do that? You may need to strip out noise words like "and" and spaces. Lord help you if someone does not use that annoying Oxford comma and puts "1, 2 and 3" instead of "1, 2, and 3"
If not, you can brute-force the T-SQL with a function that does it. Now your filter table is things like:
One, 1
One, 2
One, 3
etc,
Now, join that table to the fact table on a many-to-many join. Filter for Val1 and it should work.