Forum Discussion

NB919's avatar
NB919
Regular Visitor
4 years ago

Changing the timezone to EST

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

 

Need Help

3 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      NB919
      Regular Visitor
      4 years ago

      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's avatar
        NB919
        Regular Visitor
        4 years ago

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