Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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:

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

1 ACCEPTED SOLUTION

Hi @Anonymous ,

 

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

 

2.png

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

View solution in original post

11 REPLIES 11
v-xicai
Community Support
Community Support

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
Community Support
Community Support

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.

 

2.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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.

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
Not applicable

Hi,

 

it returns "Error"

 

2019-06-04 08_32_39-B40_WHS_USERWORK - Editor di Power Query.jpg2019-06-04 08_32_53-Colonna personalizzata.jpg2019-06-04 08_33_05-B40_WHS_USERWORK - Editor di Power Query.jpg

Hi @Anonymous ,

 

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

 

1.png

 

 

 

 

 

 

 

 

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
Not applicable

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

 

1.png

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

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

 


 

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:

2.png

 

 

 

 

 

 

 

 

 

 

 

 

 

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
Not applicable

Doesn't work

 

It doesn't add offset to hour.

 

I choose "Date/Hour"

Hi @Anonymous ,

 

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

 

2.png

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards,

Amy

 

Anonymous
Not applicable

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?

Hi @Anonymous ,

 

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

 

Best Regards,

Amy

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.