Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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!)
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!)
User | Count |
---|---|
11 | |
10 | |
7 | |
2 | |
2 |
User | Count |
---|---|
14 | |
10 | |
7 | |
2 | |
2 |