Forum Discussion
Date time showing issue...
In my report i want to show a date time value .The date time value i want is american chicago date time ...How can i get ?
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)
4 Replies
nisha_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.hi,
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.
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)
