Forum Discussion
Excel - Power Query - Bank Statements - Combining Data based on Date Values, Type, Descriptions
Hello All, I am attempting to combine all my historic bank statements together by using Power Query. I have already selected the source folder to bring 2 months of PDF bank statements to try ou...
Hi jbwtp,
Thank you.
I can't seem to remove the error and replace with null value as it asks to add a date value.
There are also numerous amount values that are missing from the statement as highlighted in yellow columns, which are showing as errors, and so these values are not updating through to the balance column.
Below is what the data looks like in the 'Replaced ValueX' query step, before the code is updated to reflect the above. So not sure why the other numerical values are missing.
Can you kindly advise
Thank you so much for your help and patience in this, greatly appreciated.
Max
Have you tried the code that I provided in the previous reply? Is this not solving the problem?