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
Posts Tagged ‘Excel’
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