Recently I came across an interesting request where someone wanted to un-cumulate their quarterly YTD-figures (green) into their single quarters values (red) like so (“Unravel cumulative totals”): Task Method To (…) Read more
Comparing Table.AlternateRows with List.Alternate in Power BI and Power Query
I must admit that I had more than one unsuccessful attempt to try to fully understand how the List.Alternate-function works. What helped me at the end, was the function Table.AlternateRows. (…) Read more
Performance tip for List.Generate (1): Buffer your tables in Power BI and Power Query
Lately I was working on a fairly advanced allocation algorithm on large data which forced me to search for different tricks to improve performance than those that you can find (…) Read more
How to do a real VLOOKUP (false) in Power Query or Power BI
When you merge tables with distinct keys in Power Query you will get the same result than the VLOOKUP-function in Excel returns (if this is new to you, check out (…) Read more
Improve import of Excel sheets with empty rows and columns in Power Query and Power BI
When you import Excel sheets who have empty leading or trailing columns and rows (showing null-values), you can substantially improve the complexity and speed of your import process with a (…) Read more
Fast and easy way to reference previous or next rows in Power Query or Power BI
When you search the web for solutions to reference previous or next rows in the query editor of Power BI or Power Query, you will find many solutions that base (…) Read more