Welcome to part 2 of my series of easy Profit & Loss and other account statements in Power BI and Excel. In the first part I introduced the general principle (…) Read more
Posts in Category ‘M’
Dynamic & bulk type transformation in Power Query, Power BI and M
This is just a quick code-share-of-the-day of different scenarios for dynamic type transformation of multiple columns at once. The syntax to transform the format of 2 columns (“Column1” and “Column2”) in (…) Read more
Dynamic Power Query X-mas tree in Excel
Wishing my faithful readers peaceful and happy holidays. Hope you enjoy my jumping Power Query X-mas tree: It changes his size or decoration randomly every time you press refresh: Totally auto-M-agically 😉 (No (…) Read more
How to store tables longer than 1,1 Mio rows in an Excel-sheet using Power Query and JSON
If you are working Power Query, you might come into a situation where you would like to make tables accessible from outside that file, that are longer than the 1,1 Mio rows (…) Read more
Incremental load in PowerBI
Edit 2017-Jan-13: You’ll find a more recent version that doesn’t use hacks for incremental load here (but that also won’t work in the service): http://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/ If you want to perform (…) Read more
Easy Profit and Loss and other (account) scheme reports in Power BI and Power Pivot using DAX
This is about an easy way to create typical finance reports like Profit and Loss using DAX that (unlike all other solutions I’ve come across so far) can be handled with (…) Read more