Adding daily data to historical table

Hi gheisargheisar 

It should be possible in some case.

1. Assume your data is local, you have different files for historical data and current data.

In this case,

• Name the files with dates information.
• Make the historical data file and current data file in the same folder, then connect to the folder with Power BI.
• Create a copy the original query in Edit queries, one query to show the last file(current data), another to show historical data.

References:

https://community.powerbi.com/t5/Desktop/Historical-data-when-changing-data-sources-every-month/td-p/515275

https://insightsoftware.com/blog/power-bi-load-data-from-folder/

https://medium.com/@wkrzywiec/getting-data-from-the-latest-file-in-a-folder-using-power-query-51dfa4bff711

 

2. If your data is online and changes everytime, please refer to the thread which is much helpful.

https://community.powerbi.com/t5/Desktop/store-historical-data-from-Power-BI-Online/m-p/128189#M54447

https://community.powerbi.com/t5/Desktop/Storing-and-using-information-from-a-dynamic-data-source-using/m-p/207293#U207293

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.