Create table to store historical data pulled from another table

[roxmasters20]

Hello All,

I am interested in creating a table stores historically data on customer account balances once it goes below a set number. 

The source table stores current account balances as at time of data refresh and overrides data from the previous day. 

The new table will basically pull entries in the main table and store them daily before they are deleted which woud then give the ability to see the historically trend. 

Any assistance will be appreciated.

Thanks.

[amitchandak]

@roxmasters20 , refer if these can help

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...

https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/