Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
5 | |
3 | |
3 | |
2 |
User | Count |
---|---|
12 | |
11 | |
7 | |
3 | |
2 |