Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
hdhillon
Frequent Visitor

Take Monthly Snapshot of data. But only once a month

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) 

 

 

3 REPLIES 3
hdhillon
Frequent Visitor

Thanks for the response,

 

I have one field that is called status and this changes from

  • Open
  • In Progress
  • Closed

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

Do you have an open date and a closed date column?



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
bcdobbs
Super User
Super User

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.



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.