Forum Discussion
Helper IIIDate time showing issue...
nisha_deepak If Utc DateTime is a column in your report, you'll want to reference that column in the function, not just UtcNow(), for example, click New Custom Column, then enter this formula, replace [Utc DateTime] with the name of your datetime column
=DateTime.AddZone([Utc DateTime], -6)
Super Usernisha_deepak ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
refer if these can help
https://community.powerbi.com/t5/Desktop/Convert-utc-to-local-time-zone-using-Power-Query/td-p/45533
https://www.poweredsolutions.co/2019/10/21/handling-different-time-zones-in-power-bi-power-query/
Appreciate your Kudos.
Helper IIIhi,
currently utc datetime value is showing as column value in my report.I want to change utc to american chicago date time value in my report as column.Now i added a custom column with DateTimeZone.SwitchZone(DateTimeZone.UtcNow(), -6 ) like this,,,Is this correct.
- AllisonKennedy
Community Champion
nisha_deepak If Utc DateTime is a column in your report, you'll want to reference that column in the function, not just UtcNow(), for example, click New Custom Column, then enter this formula, replace [Utc DateTime] with the name of your datetime column
=DateTime.AddZone([Utc DateTime], -6)