Share
Report
4Hello - 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.
Categories:
I have the same question (0)
All responses (
Answers (
