26 - Combining steps into one step in Power Query
You may want to chain multiple steps together into one step in Power Query. This is fine for simple steps (e.g. adding multiple empty columns, rounding a number down, capitalizing the first letter of a column), but quickly becomes difficult to follow.
The trick is that any function that takes a table (add a column, change type), can also take an intermediary table as its argument. You don't HAVE to refer to the last step as your table.
Chaining functions with the "&" symbol doesn't seem to work, or at least I couldn't get it to work.
Watch video 26 - Combining steps into one step in Power Query online without registration, duration hours minute second in high quality. This video was added by user WesleySon 06 June 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,973 once and liked it 11 people.