Forum Discussion
odonnelljuan
2 years agoNew Member
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, bu...
- 2 years ago
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!)
lbendlin
Super User
2 years agoA 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!)