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
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
Is it time to remove detail fields from our cubes?
During my evaluation of Power Query as a reporting engine I wondered why we should keep detail fields in our cube at all if the preferred output is a flat (…) Read more
Report Design with Power Query (1): Cascading Time Granularities
Cascading Time Granularities When the client is not happy with the pivot report layout options on cubes in Excel, my usual reaction is “OK no problem, then we’re going to (…) 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