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 ‘Excel’
How to auto-parametrize your Power Query queries
This is about a technique that I’m going to use in my upcoming articles on ICT reconciliation. But as it is useful in other areas as well, it’s getting its own post (…) Read more
How to compare everything with everything using Power BI or Power Query
A question in Mr. Excel-Forum about how to design your data model if you want to compare values from 10 different (fact-) tables with each other got me curious: (…) Read more
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
Filter SQL-server queries with Excel-tables: Query folding limitations and bug workaround
Power Query provides excellent functions to filter your SQL-Server queries by complete Excel-tables instead of just single parameters (like in all other Excel-based approaches). But you need to take care that (…) Read more
Excel Cubefunctions: Trick for dynamic sets
Today I read Andrew Todd’s brilliant guest post on Powerpivotpro.com about some really cool tricks on cubefunctions. The second one shows a very elegant solution to what I’ve formerly done (…) Read more