question

MarcBergmans-8619 avatar image
0 Votes"
MarcBergmans-8619 asked MarcBergmans-8619 action

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

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.

power-query-not-supported
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MattAllington-5456 avatar image
1 Vote"
MattAllington-5456 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MarcBergmans-8619 avatar image
0 Votes"
MarcBergmans-8619 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MarcBergmans-8619 avatar image
0 Votes"
MarcBergmans-8619 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.