Changing the timezone to EST

[NB919]

Hello,

I am having trouble changing the time from UTC to EST. I found a post on here that gave me this equation

I put it in and I got this error message

The data is the time of the call rounded down to the nearest hour

[GilbertQ]

Hi @NB919 

This is what you would need to do below which will take it to EST by going back -5 hours using the Duration function.

=DateTimeZone.FixedLocalNow()+ #duration(0,-5,0,0)

[NB919]

My goal is to convert data that is by default UTC in Power Bi to EST. is there an easy way to do that in Power Bi? I also tried 

.

This is more in line with what I want to do. I have thousands of rows that are all UTC that I need to be EST. I also need to keep the date and time the same as when it first comes in, as its useless to me to have them all be at the same time now.

your answer just returned this

[NB919]

I am wondering if its where the data is coming from that is in UTC, not power bi making it utc