Convert UTC Date to Central Standard Time

[Anonymous]

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

[Anonymous · Accepted solution]

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]

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]

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]

Is it showing to your report users in UTC?

[Anonymous]

Yes it is