cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bdn008 Frequent Visitor
Frequent Visitor

Is there a way to schedule a calculation (and freeze results) in Power BI?

Hello PBI mates,

I am looking for a way to schedule a measure calculation and freeze the results into a table for that run. In other words, I already have a measure that is always running in my set BUT for monthly tracking of KPIs, for example, when I am measuring a continuely changing value over time, I want to “freeze” that value at the end of the month (for example).

 

Thanks.

6 REPLIES 6
Super User
Super User

Re: Is there a way to schedule a calculation (and freeze results) in Power BI?

@bdn008 why not you have measure that can be calculated in point of times. May be if you explain your question little more with example dataset and expected output, it will help.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





bdn008 Frequent Visitor
Frequent Visitor

Re: Is there a way to schedule a calculation (and freeze results) in Power BI?

@parry2k, the simplest way I can explain is that I have date columns in my dataset that are not constants over time. For example if I have a 'Last-Updated' time stamp and I am refreshing my data periodically, that value on the same record will change continuously. The same with ‘Due-Date’ that could change any time. From what I know about DAX, there is no filter or trigger on a time-line. But I am willing to learn.

 

I need this as I have KPIs that track my metrics of compliance on a monthly basis. So in my mind, a scheduleed calculation at the end of the month would have been perfect alongside freezing those calculated values in another table for safekeeping.

Super User
Super User

Re: Is there a way to schedule a calculation (and freeze results) in Power BI?

@bdn008 this is tough one but one with some tricks it can be achieved? How often you are going to refresh your data? How big is your data table?






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





bdn008 Frequent Visitor
Frequent Visitor

Re: Is there a way to schedule a calculation (and freeze results) in Power BI?

@parry2k, My data set is not huge but growing and is a few thousand rows right now. I am refreshing my data a few times a day and I need to (calculate and ) freeze some of my measurements at the end of each month.

I heard before some ideas dealing with cloning the dataset with frozen values, but I never liked that idea as it will grow by data set every month and will complicate my other calculations.

Super User
Super User

Re: Is there a way to schedule a calculation (and freeze results) in Power BI?

@bdn008 it is not about taking snapshot of calculation, it is about taking snapshot of dataset before each refresh , calulation can be easily recreated if we have snapshot of data.

 

 






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





bdn008 Frequent Visitor
Frequent Visitor

Re: Is there a way to schedule a calculation (and freeze results) in Power BI?

@parry2k, I am listening and open to any idea you might be able to suggest. 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 103 members 1,455 guests
Please welcome our newest community members: