Log In
Register
Home
Pivot Tables Quick Start
Dashboards
Power Query
Power BI
May 16, 2021
Offline
Hello there
Last time I posted a query, I had the dates in the actual and budget sheets with different dates (01/07/2021 v 21/07/2021) so Power Pivot would not append budget and actuals. This time I have checked the formatting up, down, and inside out for both sheets and on this one allocation line (1007 - achieve rate) it will not append. All other allocation lines work in exactly the same file, but not this one.
Is anyone able to have a look and assist, please?
Many thanks and have a great evening!
Trusted Members
October 18, 2018
Offline
Is this the type of presentation you are looking for? If so, it is a merge (join) in PQ and not an append
File attached
Pivot Tables Quick Start
Dashboards
Power Query
Power BI
May 16, 2021
Offline
Hello Alan
I can't download the file you attached - would you mind uploading again?
I tried merging, and excel won't allow me to complete the steps required, as the final 'OK' button is greyed out. I am possibly doing something wrong, but it seems pretty intuitive...
I have followed a tutorial from Mynda called 'Combine Excel Worksheets with Power Query, and she definitely appends and then groups the data. The process has worked just fine with all my other data - just not this one allocation code.
Many thanks
1 Guest(s)
