Forum Discussion
Filtering table with a selected value
Hi, I need to create a copy of Table1 with some selected rows only, based on the value of Table1[column1]. If that value were some constant 'a', I could write : Table2 = Filter('Table1', 'Table1...
Hi Amit, The slicer was a guess. It could be somethink else. Basically the question is:
How do you copy part of a table (by part of I mean rows, i.e. all columns with just some rows) filtering on some "desired value selected by the user" ?
Hi, Maurus
I thought of a way to create parameters in pq, but this is not very convenient for users to change. If you can make it clear what you want to use table2 for, I think I might be able to help you think of a workaround.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.