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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Anonymous
Not applicable

Add Integer (hours) to a Date Time with DAX

Hello all,

 

I need your help. In order to convert UTC time to Zone Time depende from the region, I creat a column "hours" with the number of hours to add or substract from the UTC Date Time. Whant I want now is to add this hours to my Date time column. 

For example :

My column date time= 07/12/2021 10:37:30

and hours column(type whole number)=5

So new column = 07/12/2021 15:37:30

I want to do that with DAX ? how I can do that ? Thank you for your help.

 

Best

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

@Anonymous 

This works

Column = 'Table'[DateTime] + 'Table'[Hours]/24

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

1 REPLY 1
PhilipTreacy
Super User
Super User

@Anonymous 

This works

Column = 'Table'[DateTime] + 'Table'[Hours]/24

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.