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 ‘M’
Blending data in PowerBI like in Tableau
Today I came across a question in the PowerBI-forum if blending data was possible in Power BI like in Tableau. Although I wouldn’t necessarily recommend it, it’s definitely is a nice (…) Read more
Dynamically flatten Parent-Child Hierarchies in DAX and PowerBI
If you use DAX to flatten Parent-Child hierarchies you will end up with a table that has a static number of columns (like described here). If you need a dynamic (…) Read more
Automatical or Bulk- Rename Columns in Power BI and Power Query
Edit 7th Feb 2017: Friendly reader Roknic pointed out in the comments below that there’s actually an existing function for it in M: Table.TransformColumnNames 🙂 So the first of my example (…) Read more
Conditions in FirstN, LastN and other xN-functions in M, PowerBI and Power Query
Today I discovered that we can use conditions in many of the N-selecting functions where one/I would normally expect just a number-expression for the N: Table.RemoveFirstN( table as table, optional countOrCondition as any) (…) Read more
Comfort Functions for Easy Profit & Loss statements in Power BI and Excel – Part2
Here comes some long awaited comfort functions for part 2 of my easy P&L series. In the first section I’ve presented the general principle on how to work with a (…) Read more