One of M’s advantages is that you can share M-code in textform and it will run instantly on a different computer. So no need to actually exchange a file. Provided that (…) Read more
How to handle M-code samples
If you use Power Query or the query editor in Power BI every step you take will be recorded and translated to M-code. You can share this code and it (…) Read more
Select rows that have no empty fields using Expression.Evaluate in Power BI and Power Query
This article describes the use of Expression.Evaluate as a very helpful “swiss-army-knife”-method for your Power BI toolbox as it has many more use cases than the one described below. It (…) Read more
How to use regular charts on dynamic pivot tables in Excel
There are many good reasons not to use Pivot charts as described in this article i.e. – one I would like to add is the bug when using “invert if negative”: (…) Read more
How to create a Load History or Load Log in Power Query or Power BI
If you want to collect your regularly loaded data without overwriting it or create a load log that writes the load activites with a timestamp into a table, you need to (…) Read more
Trap in Replacement function in Power Query/M/PowerBI
Recently Power Query’s replacement function greeted me with some unexpected results: I applied the same steps but sometimes replacements of blanks with nothing did what it should and sometimes not. What (…) Read more