Lance Pretorius
New Member
Hi
Every week I import an accounts receivable list in to power query. See below.
The problem I have is the second column header. Every time I run the report on a new date I get the "The column 'xxx' of the table wasn't found" error, because the date changed. How do I fix this problem?
Thanks in advance.
Every week I import an accounts receivable list in to power query. See below.
The problem I have is the second column header. Every time I run the report on a new date I get the "The column 'xxx' of the table wasn't found" error, because the date changed. How do I fix this problem?
Thanks in advance.
Not due on 04/24/2019 | 1 - 30 | 31 - 60 | 61 - 90 | 91 - 120 | Older | Total | |
Customer 1 | 25.00 | 60.00 | - | - | 10.00 | - | 95.00 |
Customer 2 | - | 5.00 | 4.00 | 18.00 | 27.00 | ||
Customer 3 | 10.00 | 5.00 | 15.00 | ||||
35.00 | 70.00 | 4.00 | 18.00 | 10.00 | - | 137.00 |