insert multiple columns that subtract previous columns

(0) Share

Report

Posted on by fparkington

4

Hello - I have 50+ columns that I need to calculate the difference after every 2 columns. Currently I appended my tables in Power Query and it looks like this:

DRAFT	ACTUAL	DRAFT	ACTUAL
10	15	20	10
5	4	30	100
1	2	40	50

I need it to do this:

DRAFT	ACTUAL	DIFF	DRAFT	ACTUAL	DIFF
10	15	(5)	20	10	10
5	4	1	30	100	(70)
1	2	(1)	40	50	(10)

I can add a custom column in Power query but it shows up at the end of the table and then I have to move it. Also, it is very manual and I have to do this for 50+ columns on 50+ files.

All responses (1)

Answers (0)

fparkington 4 on at

Like (0)

Report

Re: insert multiple columns that subtract previous columns

I should add that each of my files has a different number of columns as well. So if I can automate to add this difference column for any number of iterations as there is data, that is what I want to do.