Forum Discussion
TODAY( ) (DAX) does not update when published
Hi, I have a calculated colum based on a silmple formula that uses TODAY () (also tried with UTCTODAY) - like =Table[DATE]>TODAY() and it works as expected in PBI Desktop and every time I open it, but when I publish the report TODAY() stales at the date when it was published.
The report doesnt need scheduled refresh (it is a google connection so actually it "cant"), but at least I was expecting that TODAY() would refresh automatically; even if a hit the "Refresh" button in the PBI Portal it doesnt change.
Not happy with this feature. Does anybody have a workaround to this?
Thanks
A calculated column is calculated once, during the semantic model refresh. If you want TODAY() to be meaningful you need to use it in a measure, or do daily refreshes (early in the day too!)
1 Reply
A calculated column is calculated once, during the semantic model refresh. If you want TODAY() to be meaningful you need to use it in a measure, or do daily refreshes (early in the day too!)