Timesone In Powerbi Desktop

Hi Anonymous ,

You can use DateTimeZone.SwitchZone function to switch your table date time column [DateKey] to local time via copy and paste the code below , assuming the " 8 " is hours , and "10" is minutes ,which is the changed hours between IST timezone and EST timezone.

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

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.