how to capture and store data at a fix time

[Anonymous]

is there anyway to write a method to capture yesterday total inventory bins counts? 

E.g if the data refreshes at 12pm today; it will return a set of "1000 floor bin & 1000 external bin"

Then at 8pm today; it will return a set of " 500 floor bin & 1000 external bin" 

So, is it possible to set a method to capture the and locked on the result return on 8pm daily into a table?

Date	floor bin	external bin
28/4	500	1000
29/4	800	500
30/4	1000	500
1/5	1500	2000
2/5	2000	1000
3/5	500	500

The struggle i'm having is downloading a mass list of inventory record and its transaction to performs the calculation to just get 3 different value ; the whole duration for the system to extract the data takes up to 1h daily and we need to update it 3 times per day. 

[amitchandak · Accepted solution]

@Anonymous , not very clear. Do you want to create a snapshot?

refer to DAX append

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[Anonymous]

the 2 link helped a lot; it solve 80% of thr hurdle on the data stacking part.