Forum Discussion
Static Varable
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.
I created the table with Power Query as advised and adjusted my DAX VAR expression to use the table data from the query table. The updated expressions worked as expected. When I reopened the dashboard the next day before 2PM the Power Query was re-evaluated and the prior days data was no longer visable. I did not refresh the dashboard and its obvious the Power Query table was refreshed when the dashboard was opened.
Table Query:
CurrentDay = {datevalue(format(today()-1,"MM/DD/YYYY"))}
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.