Recently I’ve distributed some techniques for partial matches or relative joins between tables using PowerQuery or the query editor in PowerBI. They are very flexible and powerful – yet slow. (…) Read more
Posts Tagged ‘PowerBI’
Performance difference between Excel and PowerBI with M is huge!
I knew that the performance of M in the query editor of PowerBI was much better than in Excel, but only today I discovered the incredible difference we actually have (…) Read more
KPIs in Easy Profit and Loss for PowerBI
Welcome to the last part of my Easy Profit & Loss series where I will cover KPIs in rows & columns: 1) KPIs in columns Show all your figures as (…) Read more
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