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
Posts Tagged ‘Power Query’
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
Waterfall Chart using Power Query
How to create a Waterfall Chart using Power Query? Target is a chart like above: Starting point, several movements & then an ending sum. Every movement starts at the end of (…) Read more