Change below time format to Perth Australia time

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),+8 ,0)

 

Then you can select NewTime column, go to Transform tab, choose Data Type and select Date/Time/TimeZone, don't forget to 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

 

Community Support Team _ Amy

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