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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lottieritchie
Helper I
Helper I

Adding time onto a variable

I have a date and time field for when an enquiry was received. 

 

In a calculated column I want to do;

if the enquiry time is after 6pm

then set the date/time as the following day at 9:00am 

Otherwise, give me the date and time the enquiry was received. 

 

I can do the obvious if statement parts, but I don't know how to set it to 9:00am the following day, rather than adding 1 day for example. 

 

Thanks 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

Hi @lottieritchie 

 

Download sample PBIX

 

Try this

 

Column = IF(HOUR('Table'[Enquiry]) > 18, DATE(YEAR('Table'[Enquiry]), MONTH('Table'[Enquiry]), DAY('Table'[Enquiry]) + 1) + 0.375, 'Table'[Enquiry])

 

 

addtime.png

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

2 REPLIES 2
lottieritchie
Helper I
Helper I

Legend - works great. Thanks Phil. @PhilipTreacy 

PhilipTreacy
Super User
Super User

Hi @lottieritchie 

 

Download sample PBIX

 

Try this

 

Column = IF(HOUR('Table'[Enquiry]) > 18, DATE(YEAR('Table'[Enquiry]), MONTH('Table'[Enquiry]), DAY('Table'[Enquiry]) + 1) + 0.375, 'Table'[Enquiry])

 

 

addtime.png

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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