98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Merging data to see differences over time | Excel forum
Merging data to see differences over time | Excel forum
Resolved · Low Priority · Version 2016
Rachael has attended:
Power BI Modelling, Visualisation and Publishing course
Power BI DAX course
Merging data to see differences over time
Hi,
I need help tracking changes to data.
Each month i get a claims report some of the claims stay the same but others increase/decrease. As well as this new claim are added each month.
Is there a way i can use power bi so any large changes or additions are easily noted?
RE: Merging data to see differences over time
Hi Rachael,
Thank you for the forum question.
The right solution is to have a record for each change in the transaction table (Fact table) with the date of each transaction (each change). You can then use the PREVIOUSMONTH dax function to compare the values up against previous month.
You can also merge the data, but this will give you problems, because you will have new claims added to the list and the merge tool in the query editor cannot pair the two table.
In the source file add a new record for each new claim and add a new record for each change and a date for the change. Then you will keep the historical aspect and you will not need to add new tables to Power Bi each month. It is the best solution.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Mon 22 Apr 2019: Automatically marked as resolved.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlinesExcel 2010 allows you to change the colour of grid lines instead of keeping them in boring black. |