Date time showing issue...

[nisha_deepak]

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 ?

[AllisonKennedy]

@nisha_deepak  You could try in DAX a new measure: 

Time =

UTCNOW()-TIME(6,0,0)

[amitchandak]

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

[nisha_deepak]

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.

[AllisonKennedy · Accepted solution]

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