Convert UTC to Local Time Dynamically

[Anonymous]

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-sa...

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.

[ERD · Accepted solution]

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.