Forum Discussion
Solved
How to change day start time
Hello, Im trying to change the start time for day filter. The basic default way of pbi assign 00:00 as new day, but, for enterprise propourses, i need to start a new day on 6 am. This way, the ...
kevinEGE , Say you have datetime field , you can assign date to like this
New column =
var _time = timevalue([datetime])
var _date = datevalue([datetime])
return
if(_time<time(6,0,0), _date-1, _date)
It worked! Thank you so much!