Forum Discussion
elijah2018
8 years agoHelper I
Filter ALL tables in PowerQuery based on parameter?
Hi community,
I have about 20 tables where in each of the tables have a Customer column. There are three customers C1,C2,C3, if I only want to load the rows in each tables containing C1 in the Customer column, is there then a way to filter ALL 20 tables at the same time without having to manually filter all tables one by one ?
Thanks in advance
Best regards
Elijah
Only if they share the same source - then you could set the filter there.
1 Reply
- ImkeFCommunity Champion
Only if they share the same source - then you could set the filter there.