Skip to main content

    Power BI

    Needs Votes

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

    Vote (65) Share
    Brent Frandsen's profile image

    Brent Frandsen on 12 Dec 2015 01:24:48

    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/

    Comments (2)
    Brent Frandsen's profile image Profile Picture

    Andy Clapham on 27 Jan 2021 18:43:54

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

    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?

    Brent Frandsen's profile image Profile Picture

    Paola Jafrancesco on 09 Sep 2020 12:23:47

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

    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.