When reading horror-stories about Excel-hell describing how dangerous it is to use Excel in corporate environments, I cannot help but to think of this hilarious video describing the fatal consequences of acting without (…) Read more
Posts in Category ‘Power Pivot’
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
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