Forum Discussion
Solved
DateTime.LocalNow
Good Morning I'm calculating the difference between DateTime.LocalNow and the date of a work order. My question is: does a calculated value based on DateTime.LocalNow automatically update each d...
If it is part of the query, then DateTime.LocalNow will evaluate each time that the query refreshes, so you would have to actively refresh the data. If you want to do it in DAX, it would be the TODAY() or NOW() function and that would be updated each day automagically without a data refresh. Calculated columns in DAX are evaluated when the data model is opened/accessed.
Good Morning
I'm calculating the difference between DateTime.LocalNow and the date of a work order. Can anyone tell me if the calculated field automatically updates each time the file is opened or do you have to actively refresh the data. Thanks