Forum Discussion
Solved
I need to see the differences between updates of data
Hi everyone, someone knows how can I see the different between updates? I have this problem in my forecast file, I try predict the invoice in march but sometimes I fail and need to change for apr...
Just merge the 2nd file to the 1st file, then calculate the difference with a Custom Column in Power Query.
- use the Merge button on the home ribbon then configure as shown below:
- Expand the 2nd column, Invoice column only:
- Add a custom column with the calculation you need.
- end result:
- use the Merge button on the home ribbon then configure as shown below:
Hi edhans
Thank you for your help. I don't get in one thing.
In this case I need to have 12 files one for month to compare him, right? Is not possible compare the historic with the new one and show the differences?
edhans
Community Champion
Community ChampionYou can but now that is a more complex set of queries that will dynamically split into the parts you need then merge back. 100% doable for sure. But it gets a bit more complex.