Forum Discussion

theBlessedCobba's avatar
theBlessedCobba
Frequent Visitor
4 years ago

Date Time Fields

Hi All,    I'm getting a date and time from a sharepoint list and im struggling to get the field to show in my local time zone in power bi desktop    I just want to display this date and time in ...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
4 years ago

Can you please show a screenshot that shows other number aside from 10 as the timezone?

  • danextian's avatar
    danextian
    Icon for Super User rankSuper User
    4 years ago

    That is weird.

    What happens if you switch the timezone to just UTC using each DateTimeZone.ToUtc?

      • danextian's avatar
        danextian
        Icon for Super User rankSuper User
        4 years ago

        Try doing it this way

        DateTimeZone.SwitchZone ( DateTimeZone.ToUtc ( [Column] ), 10 )