Convert utc to local time zone using Power Query

[lmandrade]

Would i like to convert a column [CreatedOn] Table [Opportunity] found in (UTC + 00: 00) to (UTC + 03: 00) Brazil. I need to create a new column to Power Query (Add Column). Can anyone help me? Thank you.

[v-caliao-msft · Accepted solution]

@lmandrade You can use DateTime.AddZone function to achieve your requirement. This function adds the timezonehours as an offset to the input datetime value and returns a new datetimezone value.

DateTime.AddZone([CreatedOn],3)

Reference
https://msdn.microsoft.com/en-us/library/mt253514.aspx

[lmandrade]

I will test your option as well. Grateful for the support!

[ImkeF]

Is this what you need?: https://msdn.microsoft.com/en-us/library/mt253522.aspx

[lmandrade]

I'll try. It looks like it might work. I'll be back here to tell if it worked ! Thank you.