Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

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

Kindly help if its possible.

Regards,

Himanshu

amitchandak
5 years ago
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

4 Replies

amitchandak
Super User
5 years ago
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
  Not applicable
  5 years ago
  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
    Super User
    5 years ago
    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))

Related content