Converting Time Zone

[Anonymous]

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 time zone on my report.

Kindly help if its possible.

Regards,

Himanshu

[amitchandak · Accepted solution]

@Anonymous , you have UTCNOW  in dax

a new column or measure like this

time with zone = UTCNOW() - time(6,0,0)

Should give you

refer: https://www.youtube.com/watch?v=w3mLeLv-Kj0

[Anonymous]

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

[amitchandak]

@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:

https://radacad.com/showing-current-time-and-latest-refresh-time-at-local-timezones-in-the-power-bi-report

Add hours

[DateTime] + #duration(0,6,0,0))

[Anonymous]

@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