Power Query datetimezone type

[deLockloire]

Hi,

I have a query with a column that looks like this:

2024-02-26T14:17:42.676231+01:00

If I change it to datetimezone type, it recognizes the parts properly and changes the data to this:

2024. 02. 26. 14:17:43 +01:00

However, when I load it to a table, the result is this:

​ 2024.02.26 14:17:43​

This data is clearly not adjusted for the timezone offset. How can I have PQ to add the timezone to the time so that the end result look like this:

​ 2024.02.26 15:17:43​

Thanks,
deL

 

[deLockloire]

Anyone?

 

[deLockloire]

Okay, in the meantime, I found how to solve this. Firstly, I misunderstood how datetimezone type functions. What I really wanted (and only realized later) is to show everything in local time, which you can achieve by writing this line into your M formula:

#"NAME_OF_THIS_STEP" = Table.AddColumn(#"NAME_OF_PREVIOUS_STEP", "NAME_OF_NEW_COLUMN", each DateTimeZone.ToLocal([NAME_OF_COLUMN_CONTAINING_DATETIMEZONE]))