Reading Rob Collie’s latest cool blogpost on how to retrieve slicer selections in Power BI, I couldn’t stop thinking of how awesome it would be, if we could use this (…) Read more
Posts in Category ‘Cube’
Guide for switching Signs in Power BI and Power Pivot (bypassing Unary Operators in DAX)
In finance & accounting, you very rarely report the figures with the signs of their source systems, but switch (certain) signs according to different needs. Instead of using unary operators (…) 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
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
Power Query Management Studio reloaded: Now supports MDX
Very happy to see that my Power Query Management Studio isn’t just perceived nerdy but useful as well 🙂 Thanks to Dusty for his nice review. So let’s push it a bit further (…) Read more
Is it time to remove detail fields from our cubes?
During my evaluation of Power Query as a reporting engine I wondered why we should keep detail fields in our cube at all if the preferred output is a flat (…) Read more