26 - Combining steps into one step in Power Query

Опубликовано: 06 Июнь 2023
на канале: WesleySon
1,973
11

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.