Archiving historical data with Power BI

[bongwooklee]

We'd like to have a historical weekly view of the status of our clubs. The problem is that the status is stored in a column and it changes over time. When the status changes (a new status overwriting an old status), we lose historical data. We're wondering if we can archive weekly snapshots in a separate table. Feels like a trivial task... but can't find a way to do it with Power BI. Does any of you know how to do it?

[mz1290]

How did this end up working out for you?  I'm currently encountering a similar issue with a report that I manage on a weekly basis.  I have static fields that can change week-over-week and I need to track those trends.  Currently, I am doing this manually by archiving excel spreadsheets and time stamping each line item.

[Anonymous]

I think this may help: http://www.thebiccountant.com/2016/02/09/how-to-create-a-load-history-or-load-log-in-power-query-or-...