Forum Discussion
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 april (for example). I need to have a report that tell me how much times i fail. Is this possible?
Thank you 🙂
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:
5 Replies
- Greg_Deckler
Community Champion
Would need to see example data to know if there is a solution to this. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
I Greg thank you for the quick answer.
So this is an example of what I pretend to do. In first file from one drive, sharepoint or just a excel I predict the invoice of the month for person.
First previson of invoice for january Name jan/20 Peter 500.00 € Jack 750.00 € Amanda 1 000.00 € In the end of the month I have a second file, with the really invoices of each one of them. This file can be a update of the first one, because i dont want to have 12 queries ( one for each month). The best way is to read the differences between update's.
Realize in january Name jan/20 Peter 400.00 € Jack 500.00 € Amanda 1 000.00 € For this case I need a report that see the differences between files and give me this.
Differences between them Name jan/20 Peter - 100.00 € Jack - 250.00 € Amanda - € - edhans
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:
