Today I discovered that we can use conditions in many of the N-selecting functions where one/I would normally expect just a number-expression for the N: Table.RemoveFirstN( table as table, optional countOrCondition as any) (…) Read more
Posts Tagged ‘Filter’
How to auto-parametrize your Power Query queries
This is about a technique that I’m going to use in my upcoming articles on ICT reconciliation. But as it is useful in other areas as well, it’s getting its own post (…) Read more
Want to filter a PivotTable based on an external range or list?
In order to pass a list of filter arguments to your pivot table instead of selecting them all manually you can do the following: 1) Pass your filter table and your (…) Read more
Use Timeline or Slicers to filter your Power Query import
A question in the Mr. Excel forum this morning reminded me that the technique I’ve blogged about here could also be used to do simpler things like using a timeline (…) Read more