Change below time format to Perth Australia time

[Anonymous]

Hi Gurus, 

I need below time stamp

2020-04-15T05:13:19.697Z

add 8 hours and split in to date and time like below

Date                Time

15/04/2020     01:13:19

Thanks for the help

[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),+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.

[Anonymous]

Thanks a lot for the solution.

[amitchandak]

@Anonymous 

Refer: https://community.powerbi.com/t5/Desktop/Date-Field-Time-Zone-Fix/td-p/402509

https://support.helpshift.com/kb/article/how-do-i-set-my-timezone-in-power-bi/

https://docs.microsoft.com/en-us/powerquery-m/datetimezone-functions