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
Posts in Category ‘little Tipps&Tricks’
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
Create a Dimension Table with Power Query: Avoid the case sensitivity bug!
Creating a Dimension table from a fact table using Power Query is really straightforward using the Remove Duplicates function. However – you might experience a problem if the key to your (…) Read more
How to pivot multiple measures and columns in Power Query and Power BI
The pivot-function in Power Query lets you pivot your data within the query already. This comes in handy quite often when you want to further work on those results within (…) Read more
Search Options in Power Pivot
Search Options in Power Pivot 1) In the Power Pivot window: Ctr+F acts as a metadata-search that not only finds strings in columns but also in measurenames 2) Want to (…) Read more