Create a measure to set BusinesStartDateTime

[pkoel-asb]

Hello,

  I am trying to create a new measure that will be a date/time value. I want to use the day date provided by Today(). I then want to add 7 hours and 30 minutes. this will set the measure to today's date and the time to 7:30. Here is what I am trying to do:

BusinessDayStart =

var thisday= Date(today)+ Hour(7) + Minute(30)

return thisday

I want to do this in Dax and not M.  Any advice?

Cheers!

[DataInsights · Accepted solution]

@pkoel-asb,

Try this measure:

BusinessDayStart = TODAY() + TIME ( 7, 30, 0 )