Outdated list of time zones Time Zone

[Anonymous]

Outdated list of time zones.
Yekaterinburg now: +5 UTC
In the list: +6 UTC

[v-xicai]

Hi  @Anonymous ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[Anonymous]

The problem is not in the formulas and calculations, but in the settings of users (clients). I can correctly keep records, but a user with the settings of his time zone (name) will have an incorrect time zone in hours.

And the formulas ... Sooner or later, you update the database and a crash occurs.

[v-xicai · Accepted solution]

Hi @Anonymous ,

In Query Editor, you can use DateTimeZone.SwitchZone function to switch your table date time column [DateKey] to local time via copy and paste the code below .

DateTimeZone.SwitchZone(DateTime.AddZone([DateKey], 0),-1 ,0)

Then you can select NewTime column, go to Transform tab, choose Data Type and select Date/Time/TimeZone, and click "Close & Apply".

You can learn more: https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337

                                     https://community.powerbi.com/t5/Desktop/Convert-UTC-to-local-time-zone-in-DAX/td-p/43328

                                   https://radacad.com/solving-dax-time-zone-issue-in-power-bi

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

Best Regards,

Amy

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