Further to the comment above re extensibility, I also try to do things in PBI that don’t explicitly list all columns - just the ones I want to manipulate in that particular step. e.g.
- using a function to reorder columns in an extensible way (so we only specified the columns we wanted to put at the start, rather than explicitly listing ALL the columns we wanted)
- selecting the columns we wanted to keep then choosing ‘remove other columns’ rather than explicitly specifying the columns to keep
etc.
