"date"

2 Topics

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, 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
odonnelljuan
2 years ago Place Report Server
1.5KViews
0likes
1Comment
PBI Server- Date format issue
Hi everyone, I am currently faced with date issues, from PBI desktop to PBI Server (on-premise). How can i show it as dd/mm/yyyy without changing the browser configuration? Can it be solved by creating another calculated column or can be done in the transformation tab? For example, this application date is showing as 14/03/2001 (dd/mm/yyyy). (PBI Desktop) However, when showed on PBI Server, the application date is showing as (mm/dd/yyyy). (PBI Server on premise) Thank you.
MrOnly_One
2 years ago Place Report Server
382Views
0likes
0Comments