Tracking historical data in a live model without making the model huge
I've built a model where end users input information and it calculates outputs. This tool will be completed by end users on a adhoc basis, some will use it weekly or monthly, while others will it once in a while. One of the outputs, shown below, is based on live information in the model:
As we want to keep a record of calculated outputs, I want to develop a process where end users 'submit information' at a point in time. I think the best way to do this, is by creating an action to import the data in the formula based module into a values based module. The values based module would have the same dimensions but also have time (by days) dimension to capture when the date the import was run.
As users will not be using the submit functionality often, I have concerns that this imported module will have a huge size which will mostly be blank. Is there a better way of tracking the historical calculations?