Forum Discussion
Converting Time Zone
Anonymous , you have UTCNOW in dax
a new column or measure like this
time with zone = UTCNOW() - time(6,0,0)
Should give you
Anonymous , you have UTCNOW in dax
a new column or measure like this
time with zone = UTCNOW() - time(6,0,0)
Should give you
Thnaks for the support it has given me the desired output.
But one question, I have scheduled the report to refresh 8 times a day in the power bi service. Will the time on the report change itself by using this new dax column?
Regards,
Himanshu
Anonymous , There you might have setup like this
https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/
also refer:
Add hours
[DateTime] + #duration(0,6,0,0))
amitchandak Both the links are not solving my issue. Also the column I've created using "time with zone = UTCNOW() - time(6,0,0)" is not what I intended. After every pafe refresh the time is changing on my report. WHat I want is only when the dataset is refreshed the time should change or if I can show the next dataset refresh time in my report.
Is there any possibility for this?
Regards,
Himanshu