Forum Discussion

elijah2018's avatar
elijah2018
Helper I
8 years ago
Solved

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

  • ImkeF's avatar
    ImkeF
    Community Champion

    Only if they share the same source - then you could set the filter there.