Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Convert UTC Date to Central Standard Time

@ links to members, content   I have a datetime column in UTC time in my table.  I want to add a column to that table and convert the time to Central Standard Time.  Is there a simply way to do thi...
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

     

    You can create a new calculated column in power bi desktop by DAX:

     

    CST Time = [YourUTCDateTimeColumn] - TIME(6, 0, 0)

     

     

    Or you can create a custom column in power query:

     

    CST = DateTimeZone.SwitchZone([YourUTCDateTimeColumn],-6)

     

    For the sample .pbix file,pls see attached.

     

     Please refer to the following post for more information.

    UTC vs Local Timezone, Daylight Savings for Power BI | by Susheel Aakulu | Medium

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

lbendlin's avatar
lbendlin
Super User
2 years ago

You could do that in Power Query. But - why do you need to do it? The Power BI service will show it according to the user's timezone.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Unfortunately, in my desktop it is showing correct time.  When I publish it is showing in UTC time.  Therefore, I need to do a conversion. 

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Is it showing to your report users in UTC?

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Yes it is