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 did consider that solution! If I setup a manual table the data will be fixed and never change. I want to use TODAY() to evalute the dates based on current day, CurrDay = Today()-1 and PrevDay as TODAY-2. If I use a table I need to have a source (Excel Table, or Process a DB table) that evaluates the date and then refresh PowerBI to update the table of new source data. I work with another tool that allows global variables to be evaluated at refresh time LET v_CurrDate = TODAY()-1. They remain static as long as the refresh does not take place. If I update the dashboard at 2PM today and open the dashboard tomorrow before 2PM the dates still represent yesterday's refresh and all data is intact until the next refresh. Unless I'm missing something a new table will not solve my problem without a process to create the new dates in an updated excel spreadsheet or a DB process to update table dates and import the new dates to PowerBI.
Thanks for your response to my post
You can create today in power query with
DateTime.LocalNow()
So it will update the date every time
