Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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!)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.