Forum Discussion
Converting Time Zone
Hi All, I've created the blow last refresh time calculation. Is there a way I can convert the same to UTC -6 time zone? As of now its showing me local time zone but i want to show the UTC -6 ...
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 , 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