cancel
Showing results for 
Search instead for 
Did you mean: 
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 III
Super User III

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 III
Super User III

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.