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.
All,
How do I build a table that contains a snapshot of data? Which will do it the first time I refresh data for the month. (If there is already a snapshot there, then it wont do it again) I have a calendar table built into my model and thats linked upto my main data table
Lets assume its a Hospital Cases dataset. I would like to record a snapshot of how many cases were open in the month. (Before they get closed off. Some cases get closed in a few days, others can take months)
Thanks for the response,
I have one field that is called status and this changes from
So if the status changes the field gets overwritten. This is why I want to take a snapshot each month and then compare how many were Open and Closed each month in a year for example
There's no direct way of doing it.
Tweaking the pattern as suggested in https://whatthefact.bi/power-bi/power-bi-datamart/persisting-temporary-accessible-data-via-power-bi-...
could be an option.
Alternatives are persisting it in a separate sql database or data lake.
Is there a reason you need to snapshot the data though? Can you not just have a live table of cases with a start and end date. You could then write a measure to calculate how many are closed each month.
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 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |