Add UTC offset to client time

[Anonymous]

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:

27/05/2019 07.00 to 27/05/2019 07.00 +02:00

Is it possibile to convert 27/05/2019 07.00 to 27/05/2019 09.00?

Thanks

[v-xicai]

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

[v-xicai]

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]

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]

Hi,

it returns "Error"

[v-xicai]

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]

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.

---

[v-xicai]

Hi @Anonymous ,

Yes, we have successfully added the time Zone information into the time. Then you can select NewTime column, navigate to Transform tab, choose data type and select Date/Time/TimeZone. For example like picture below:

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]

Doesn't work

It doesn't add offset to hour.

I choose "Date/Hour"

[v-xicai · Accepted solution]

Hi @Anonymous ,

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

Best Regards,

Amy

[Anonymous]

Yes but this only format column.

I dont want hour +offset. i only want hour.

Not 06/10/2019 11.20.00 +2.00 but i want 06/10/2019 13.20.00 .

Do you understand?

[v-xicai]

Hi @Anonymous ,

Don't forget to click "Close &Apply".

Best Regards,

Amy