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

Marc Bergmans 101 Reputation points
2021-03-01T14:32:58.863+00:00

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.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,251 questions
0 comments
Accepted answer
  1. Matt Allington 332 Reputation points MVP
    2021-03-05T09:26:09.743+00:00

    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.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Marc Bergmans 101 Reputation points
    2021-05-08T15:28:08.54+00:00

    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.

    0 comments
  2. Marc Bergmans 101 Reputation points
    2021-05-08T15:29:05.41+00:00

    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.

    0 comments