Retaining hisorical data and adding to this monthly

[Anonymous]

Hi There, Could anyone help with the below scenario. 

I need to pull in monthly data and keep a snapshot of this at that point in time, adding the new month 'snapshot' to the historical data each month. 

In this scenario I need to count the number of outstanding items for, say, january and store this info, then count the number of outstanding items at the end of feburary and add this data to the history. 

I could union the tables and manually intervene to create the new month, but we really need this to be an automatic refresh. I have considered using a flow, as was suggested in other posts, but I dont think this would be able to add the 'new' month to the hisotrical data each month?

Any ideas would be appreciated!

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

If you don't think flow will work, you could refer to this solution and use PowerShell to do it automatically.