Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Add UTC offset to client time

Hi, i have some problems with UTC time.   Data in my reports is 2 hours less than real.   I tryed to convert hour to my timezone and it works but by this way i have hour +offest.   Example: 2...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    Enter into Query Editor, Transform -> Date/Time/TimeZone. For example like picture below:

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi Anonymous ,

 

You can use DateTimeZone.SwitchZone function to get your offset date time in Query Editor.

 

DateTimeZone.SwitchZone(DateTime.AddZone([DateKey], 0),+2 ,0)

 

For example following steps in the picture below.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

You can learn more: https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337

                                     https://community.powerbi.com/t5/Desktop/Convert-UTC-to-local-time-zone-in-DAX/td-p/43328

                                   https://radacad.com/solving-dax-time-zone-issue-in-power-bi

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

 

Best Regards,

Amy

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi  Anonymous ,

 

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

 

Best regards

Amy

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    it returns "Error"

     

    • v-xicai's avatar
      v-xicai
      Community Support
      7 years ago

      Hi Anonymous ,

       

      Maybe you have missed the comma before "+2".

       

       

       

       

       

       

       

       

       

      Best Regards,

      Amy

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Yes it works but it returns time +offset (01/05/2019 04.00.00 +2.00).

         

        I don't want this. I want 01/05/2019 06.00.00 .

        v-xicai wrote:

        Hi Anonymous ,

         

        Maybe you have missed the comma before "+2".

         

         

         

         

         

         

         

         

         

        Best Regards,

        Amy

         

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.