This article shows a trick for a little problem that annoyed me for quite some time: How to get Table.TransformColumns transforming the values of a column with a reference to a value (from the (…) Read more
Posts in Category ‘M’
SQL-query folding bug still alive and sucking in PowerBI and PowerQuery in Excel
Edit: There is currently no interest at Microsoft to change the current behaviour: http://community.powerbi.com/t5/Issues/Bug-Query-folding-not-working-with-non-SQL-datasource/idi-p/225100#M11611 . I found that this workaround works also pretty well (faster in most cases), as long (…) Read more
Non-linear Break-Even Analysis in PowerBI
A break-even analysis tells you at which value of the parameter in question your profit-calculation will turn positive (link). Here we need to sell at least 173 at a given (…) Read more
Import multiple files from Dropbox folder into PowerBI and Excel (via PowerQuery) at once
Edit 2nd October 2021: Unfortunately this method doesn’t work any more, as Dropbox now requires proper OAuth authentication. Below you’ll find a video where you can see how easy it is to (…) Read more
Unpivot by number of columns and rows in PowerBI and PowerQuery in Excel
Today I’m sharing with you one of my killer M(inja)-strikes: Unpivot a table by simply passing the number of columns that shall remain (at the left side of the table) (…) Read more
Analyse your memory consumption in PowerBI
It’s downing a bit slowly on me how awesome the direct retrieval of DMVs in PowerBI and PowerQuery actually is. Just see how easy we can build a cool view (…) Read more