Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |