Convert UTC to UTC Brazil (-03:00:00)

[admfabiomachado]

Hi, the logoff column is in datetime format, with the data being extracted from the stoptime column. Unfortunately the column is in the UTC time zone. How do I convert to UTC Brazil (-3 hours)? I need to creat a new column or edit the logoff column

[dvnnnaidu]

@admfabiomachado , you can add coumn using DAX in Data or Report as below

New Column = 

([logoff)-TIME(3,0,0)

[clubspec]

If the UTC time is 3 hours different in your case try just edit the fomula with - ((1/24)*3)

[blopez11 · Accepted solution]

Add a step to convert logoff to datetime format, then add a variation of the following:
#"Added logoff (UTC)" = Table.AddColumn(#"*** your prior step here ***", "logoff (UTC)", each DateTime.AddZone ( [logoff], 0 ), type datetimezone ),
#"Added logoff (Brazil)" = Table.AddColumn(#"Added logoff (UTC)", "logoff (Brazil)", each DateTimeZone.RemoveZone ( DateTimeZone.SwitchZone ( [#"logoff (UTC)"], -3 ) ), type datetime),

Hope this works for you,

[camargos88]

Hi @admfabiomachado ,

Check this function:

https://docs.microsoft.com/pt-br/powerquery-m/datetimezone-switchzone