Hi
I have a pbix file that pulls data from a couple of sources and brings together a mart table that i create a number of measures and visuals from.
I'd like to track this over time and the transactional data doesnt support this.
My idea is to create a snapshot of this table daily (ie freeze it in time with a datestamp on each row) and store it in a snapshot table, the following day/week/period etc the model would create another snapshot and add it to the snapshot table and repeat ad infinitum.
Is this possible in the data model? if so does anyone have any examples or ideas please?
(Ive had a team previously do this for me in sql in a data warehouse in a previous life but the company im working for at the moment are very resource light so its only a PowerBI model in the service at the moment)
