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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Freezing Data In Time

 Good morning again, everyone. 

 

 One more question, if I may.

 

 Is there a way to freeze some data in Power BI?

 

 In this case, I've calculated some results for Oct. Next month I'll update the dashboard with the new data for Nov, but I'd like the results for Oct to remain, the problem is that the data will all recalculate using the new data for this month and, thus, change the results for Oct.

 

 I could create "Data Jan", "Data Feb"... But in the long term, doing that is going to bite me in the backside, as the files become larger and larger until, finally, the whole dashboard is unusable. Is there a simple way for me to tell Power BI that I want X calculation result kept even after the data is updated?

 

 Thanks, everyone.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

If you have Premium, you could do incremental loads. Otherwise, you would need to create a query for each and after loading turn off data load for that query as you suggest.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Greg_Deckler
Super User
Super User

If you have Premium, you could do incremental loads. Otherwise, you would need to create a query for each and after loading turn off data load for that query as you suggest.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

I was afraid that would be the solution.

 

Thank you!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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