TODAY( ) (DAX) does not update when published

[odonnelljuan]

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

[lbendlin · Accepted solution]

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!)