I am trying to figure out how to go about taking a snapshot of some data. We keep a daily count of our active companies, but things are constantly changing in our database so the numbers always change. For instance, today I can get the exact active client count for 2/8/2018 which is 4,309. If I open up my PBI report in a few weeks, or even days, and want to look back to see what the active client count was on 2/8/2018, it would no longer read 4,309, but some other random number that could either be higher or lower since the data is constantly changing in our SQL database. Is there a way that each day I can take a snapshot of the date and client count on that day and have it stored in some additional table to reference? We are attempting to record customer retention and I just want the numbers as accurate as possible. Thanks!