Pivot operations in are a very handy feature in Power Query but they can slow down refresh performance. So with some bittersweet pleasure I can tell that I found a (…) Read more
Posts Tagged ‘pivot’
Perfect Analysis Services (SSAS) reports in Excel using Power Query
Excel-reports on SSAS cubes (multidimensional and tabular) can have some flaws that now can be overcome by using Power Query for sourcing your cubedata: filter your cube by complete Excel-tables without loading them to the model/cube (…) Read more
Want to filter a PivotTable based on an external range or list?
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
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