Forum Discussion
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...
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.
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
Super User
Super UserIs it showing to your report users in UTC?
Yes it is