Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Convert UTC to Local Time Dynamically

Hi All,

I have designed a dashboard, which having the DateTime column as ReadyBy which is in UTC timezone, and I need to convert this to local timezone depend on the stores available in that timezone.

 

I have used following link for reference https://community.powerbi.com/t5/Power-Query/Convert-Date-Time-in-UTC-to-Local-Time-with-Daylight-savings/td-p/789919

 

It works for me(For specific timezone), but I having multiple timezones available in my database as below:

It works for some stores but not works for other stores.

 

So Please help me to fix this.

Need Help

1 Reply

  • ERD's avatar
    ERD
    Community Champion
    5 years ago

    Hello Anonymous ,

    If I understand your requirements correctly, there is a solution in this forum: Convert-UTC-to-client-time-zones.

    You will need to use DateTimeZone.SwitchZone function.