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
Posts Tagged ‘M’
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
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
Efficiently rename columns with a function in Power BI and Power Query
Edit 2018-July-05: As it turns out I’ve missed the native function that exists with exact the same functionality: Table.TransformColumnNames Thanks to Tristan Malherbe for pointing this out 🙂 But anyway: (…) Read more
Automatically expand all fields from a JSON document in Power BI and Power Query
If you work with JSON documents that are new to you, it can be very helpful to fully expand JSON to see at a glance what’s in there. The following (…) Read more