You can make periodic snapshots of data with Tableau incremental refresh. This is a method I've found on Tableau Zen Master Joshua Milligan blog and I can say from my experience that it really works (as I'm using it at my work to catch similar data)
The only thing 'catchy' about this method is that it always has to be incremental refresh, so be careful with that, especially if you are not the only one who will be working on the workbook; once fully refreshed you are losing all the data.
Other than that I think it's a pretty neat solutions if a database you are working on does not have a table that would automatically gather snapshot data
Oh, and link to the blog post: Periodic Snapshots with Tableau Incremental Refresh | VizPainter