Forum Discussion
Create a measure to set BusinesStartDateTime
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!
Anonymous,
Try this measure:
BusinessDayStart = TODAY() + TIME ( 7, 30, 0 )
1 Reply
- DataInsights
Super User
Anonymous,
Try this measure:
BusinessDayStart = TODAY() + TIME ( 7, 30, 0 )