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 this.  All the blogs are confusing.  Do you accomplish this via power query or in the table itself. 

Show and Tell
Tips and Tricks

5 Replies

  • 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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.