Forum Discussion
Compare daily data using excel data
Hi gsmjlc,
In my opinion, I think you can add a column which used to mark the added date, then use this column to analysis the increase percent.
Regards,
Xiaoxin Sheng
Hi gsmjlc,
According to your description, you want compare multiple excel file which has the same structure, right?
You can try to store these files to folder and use power bi get data from this folder.
For detail information about use power query to compare two table, you can refer to below blog:
Compare two tables or reports using Power Query
In addition, you can also use dax function to compare tables.
Regards,
Xiaoxin Sheng
Hi Anonymous,
Thanks for the reply.
The columns will not alter but the rows will as more customers are added. I can see how this would work on the occasional report to display the changes. However I am looking to do this daily and so the combined excel sheet would become larger and larger after a month or two (I think).
Is there a way that if I drop the raw data for each day into a workbook, I can compare between each and report either numerical or % changes?
I appreciate that I may have got this completely wrong so your advice is really appreciated.
Thanks,
Alan
Hi gsmjlc,
In my opinion, I think you can add a column which used to mark the added date, then use this column to analysis the increase percent.
Regards,
Xiaoxin Sheng