The following function automatically transforms all columns to the types that have been detected in the cells of its first row. Provided they come as: Number, date or text (but (…) Read more
Posts Tagged ‘Excel’
How to expand a column that cannot be expanded in Power BI and Power Query in Excel
Especially when working with JSON-data, you might end up with a column that has elements of mixed types in it. The expand column – arrows will be missing, but some elements still need (…) Read more
Table.TransformColumns – alternative in PowerBI and PowerQuery in Excel
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
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
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