Apr 16 2020 08:05 AM
Apr 16 2020 08:19 AM
In addition. Not repeat in Power Query exactly the same set of filters as in Excel table you may add helper column to the Table as
there [A] is any column within the table assuming it has no blank values. Similar could be for the range. Formula returns 1 for visible rows and 0 for hided ones.
Within the PowerQuery as first steps filter result on zero for this column and remove it. That shall work for any filter applied in Excel sheet.
Apr 16 2020 08:39 AM
If you add helper column to the table returned by PQ such column won't disappear but it isn't in sync with the table. Not very important in this case since we use any value in current row.
But I didn't catch how entire model works. You have some source data, transform it by Power Query and return the table to the sheet. Apply filtering to the resulting Table, query now this table and return result into one more table. Like this?
Apr 16 2020 08:47 AM
Apr 16 2020 09:00 AM
Apr 20 2020 07:52 AM
Apr 20 2020 09:38 AM
Nov 24 2020 04:46 PM