Let’s go into Adam’s mind as he optimizes Power Query to make some Power BI Dataflows run faster to avoid resource usage. The result is INSANE AMAZING!

Power Query M function reference
https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference