M language - referencing previous step

[AdamO]

Hi All,

So I'm fairly new to Power BI, and I'm wondering why (for curiousity's sake more than anything) when using the Advanced Editor function in the Edit Queries screen, that the M code for a step always references the previous step.

e.g. #"Removed Columns3" = Table.RemoveColumns(#"Changed Type2",{"ExitResponse"}),
Where #"Changed Type2" is was the previous step.

This caused me a couple of trip ups when writing steps by hand, so some understanding of why it's doing it would be great to help me write better code.

Thanks!

Adam

[vanessafvg]

because m is a procedural langauge, therefore it creates everything in steps.  The last step is all the changes in the data to that point.