Solved: Convert UTC to Local Time Dynamically

Anonymous · ‎03-31-2021

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 · ‎03-31-2021

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.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.

Stand with Ukraine!

Here is an official way you can support Ukraine financially:
Come Back Alive foundation: https://savelife.in.ua/en/
Thank you!

View solution in original post

ERD · ‎03-31-2021

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.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your Kudos.

Stand with Ukraine!

Here is an official way you can support Ukraine financially:
Come Back Alive foundation: https://savelife.in.ua/en/
Thank you!