Is it possible to calculate in Excel Power Query without using the names of the Columns ?

Question

Hello,

Hello,

I need to make Excel Power Query in one column the sum of two columns and in another column i need to subtract them.
I cannot use the names of the columns because they change with every refresh.
So i want to know if it is possible to make calculations in Power Excel without using the names of the column.
Something like in Excel Column C + Column D and Column C minus Column D
So that the formula's stays correct if the Column names changes.
Is this possible ? If yes how can i do this ?

Many Thanks,

Marc.

Answer 1

My suggestion is to demote the headings. This is opposite of “use first row as header”. Instead you can “use header as first row”. Then remove the first row. You will then have standard column names based on position.

Answer 2

The solution I used i demoting Headers and use the Column standaard names to make the calculation and after the calculation i promoted the headers again.

Answer 3

The solution I used i demoting Headers and use the Column standaard names to make the calculation and after the calculation i promoted the headers again.