Edit 14-Dec-2017: Now that we can right-align text measures in PowerBI, a SWITCH-measure like here: http://www.thebiccountant.com/2017/04/24/kpis-in-easy-profit-and-loss-for-powerbi/#comment-719 is the best alternative in my eyes. No need to read on 🙂 As (…) Read more
Posts in Category ‘Power BI’
Bulk-extracting Power Query M-code from multiple pbix files in Power BI
Edit: Unfortunately this method isn’t working any more for files with the latest Power BI file formats (including the enhanced metadata format). If you want to audit or analyse the (…) Read more
Create a function library in Power BI using M-Extensions
Having the ability to use own M-function the same way than native functions in Power BI and Excel has been one of my biggest wishes for quite some time. So I (…) Read more
Custom Connector to import Google Sheets with OAuth2 authentication in PowerBI
EDIT 17th Feb 2022: Finally, we have the native connector in Power BI: Power Query Google Sheets connector – Power Query | Microsoft Docs – so no need for the (…) Read more
Number.Mod rescue pack for Power BI and Power Query
If you use the M-function Number.Mod in Power BI or Power Query and expect the same result like in Excel or DAX, you are probably in good company. But if (…) Read more
How to open a complex JSON record in Power BI and Power Query
Today I’ll show you a very useful technique how to deal with a JSON record that contains a wild mixture of different elements like this: If you click on one (…) Read more