Forum Discussion
Keep specific data from update to update
Hello all,
I receive a weekly report from our sales team with the sold units per location. After each update, I want to keep a statistic to show the evolution per location from one week to another and to show this as a chart later. Is there any way to maintain the number of the sold units for each location from update to update?
Thank you in advance!
2 Replies
so you basically get a per week report in Excel or something and then load it to a report? These files you recieve are not cumulative, but only for a given week? If that is the case, then to do it in PowerBI alone the first option that comes to my mind is to keep all the files in the same directory and make sure you have a date somewhere for reference. Then you can use PowerQuery to pull in all the files and mash them together
Hi dumeacristian98 ,
Sorry, currently there's no such feature. We can only get the last refresh date in the report.
You may submit an idea and vote for it: Ideas
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
