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
Posts in Category ‘Power Query’
How to edit M-function documentation metadata
After the great announcement yesterday that we will be able to ship custom functions within the shared environment, I’m expecting a lot of people starting to write awesome custom functions for M. Hopefully (…) 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
Machine Learning with M in PowerBI and Excel
Very often I have thought about trying M instead of R for machine learning problems in PowerBI. Not only because I’m such a big fan of M, but also because (…) Read more
Use Slicers for Query Parameters in PowerBI
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
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