Recently I picked up an interesting request to transform text with exceptions: Transform the words in a column to proper case, but keep certain keywords like in a defined list. (…) Read more
Posts in Category ‘Power Query’
Memory efficient clustered running total in Power BI
Today I want to share a scenario where a running total calculation in the query editor saved a model that run out of memory when done with DAX: Problem The (…) Read more
Unravel cumulative totals to their initial elements in Power BI and Power Query
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