What considerations are important when you decide in what order you should perform transformation steps in Power Query? Is the engine “smart” so that it can evaluate all steps and decide on the most effective execution or does it simply apply the steps one by one?
Should you remove unused columns before doing a merge between 2 tables is it not important
Is it better to do filtering as early as possible to reduce the number of rows or is it not important?
Any other considerations that are important?