Forum Discussion

lottieritchie's avatar
lottieritchie
Helper I
5 years ago
Solved

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  Oth...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    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])

     

     

    Regards

    Phil