I am pulling data from multiple spreadsheets into a table using power query, generating a table of the following format:
| Date | Description | Revenue |
|---|---|---|
| 1 | a | £1,000 |
| 2 | b | £2,000 |
| 3 | c | £3,000 |
I want to manually enter data into a fourth 'fee' column (as set out below) each month. When I come to refresh the query in the following month I want to ensure that the 'Fee' data will still correspond with the relevant month.
| Date | Description | Revenue | Fee |
|---|---|---|---|
| 1 | a | £1,000 | £1,500 |
| 2 | b | £2,000 | £2,500 |
| 3 | c | £3,000 | £3,000 |
