Forum Discussion

ElliotP's avatar
ElliotP
Icon for Post Prodigy rankPost Prodigy
9 years ago
Solved

UTC to AEST

Morning,   The DateTime column in my sql table is in UTC time, but I would like this column to be in the AEST (-10 or -11) timezone. I've read quite a lot through the forums and all of the solution...
Need Help
Show and Tell
Tutorial Requests
  • MarcelBeug's avatar
    MarcelBeug
    9 years ago

    You can use the table and function from my post as illustrated in this video:

     

ElliotP's avatar
ElliotP
Icon for Post Prodigy rankPost Prodigy
9 years ago

Evening,

 

For some reason I didn't see the post pop up a while ago, I'm so sorry. :smileysad:

 

I've had a look, I'm not sure how to create that original TimeTable? As well, the pbix will have a locale of United States as so I'm able to convert the string which my datetime is identified and stored as, into a DateTime data type.

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    ElliotP,

     

    We can switch time zone when add a custom column. I have tested it on my local environment.

    Untitled.png  Untitled1.png 

    Capture.PNG

     

    Regards,

    Charlie Liao

    • MarcelBeug's avatar
      MarcelBeug
      Icon for Community Champion rankCommunity Champion
      9 years ago

      v-caliao-msft your solution won't work in this case as it doesn't take into account Daylight Saving Time (DST) switches.

      • ElliotP's avatar
        ElliotP
        Icon for Post Prodigy rankPost Prodigy
        9 years ago

        This is the issue we are working to solve.

         

        I've seen a complicated potential solution on radacad (I can find the link if you haven't seen it before); but it relies upon working with an external API which seems a tad overkill.