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
Monthly Archives of August 2015
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
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