Forum Discussion
Solved
Static Varable
I would like to build a variables in my dashboard that stay fixed until the next data refresh. I have a dashboard that displays information for specific calendar periods, updated at 2PM daily. The ne...
Hi dbaksa ,
Is the dashboard in service or desktop?
The data will be refreshed every time when the power bi desktop is reopened.
If the scheduled refresh is not configured in the service, the data will not be refreshed automatically.
The calculated column and the query column in power query are updated every time the data is refreshed, but measure will calculate dynamically according to the current context.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks I will give that a try!!