Allow user to select time zone when converting type to date/time/timezone

[frandsb]

Currently, if converting a date/time to date/time/timezone datatype, the system applies the local timezone. Generally if I'm finding the need to add a timezone, it is because the data is NOT in my local timezone! Please allow user to choose which timezone to apply in this case. Detailed explanation and workaround provided by Ken Puls here: http://www.excelguru.ca/blog/2015/05/20/data-from-different-timezones/

[paola_jafrances]

Hello Microsoft - This is a very important function. Currently we change it manually but it can lead to a lot of errors, please consider to add this functionality.

[andy_clapham]

Agree - we're processing data from postgres with UTC dates, but obviously the users want to see that in local time. PowerBI strips out the timezone information from timestamptz and assumes local, giving us 1H offsets for dates in summer. However (@Paola) I've just tried #"Fix tzcol" = Table.TransformColumns(Source, {"tzcol", each DateTimeZone.ToLocal(DateTime.AddZone(_,0,0))}) which seems to do what I'm after - perhaps it could be useful for you?