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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.