While the relationships view of the datamodel provides a very good overview which tables are connected to each other, one cannot see at a glance on which field they are (…) Read more
Posts in Category ‘Power BI’
Performance Tip: Partition your tables at crossjoins where possible – PowerQuery PowerBI
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
Goal seeking and XIRR in PowerBI and PowerQuery
If you want to solve Excels XIRR-function with M in PowerBI or PowerQuery you have to use a goal seeking algorithm. I tried it with a binary-search and the results were (…) Read more
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
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