I have a source excel table on which I use Power Query to get a desired excel table (say Table1).

Now further I want to run a Power Query on Table1 based on the filtered rows only (which I want the query to pick up dynamically) to get another table.

How do I make Power Query pick up only the filtered rows from Table1?

​I have a source excel table on which I use Power Query to get a desired excel table (say Table1). Now further I want to run a Power Query on Table1 based on the filtered rows only (which I want the query to pick up dynamically) to get another table. How do I make Power Query pick up only the filtered rows from Table1?  Read More

​