Forum Discussion
Power BI Custom Date and Time Query
I have a Date measure that calculates the total line production in a day and they range from 12 midnight to 11.59pm. Now I need to calculate the same between 6am to 5.59 am next day. I have the below...
Anonymous , No need to change the date calendar. Change the date in fact
New column =
var _time = timevalue([Datetime])
var _date = datevalue([Datetime])
return
if(_time<time(6,0,0) , _date -1, _date)
Join this new date date column with date table
amitchandak
Super User
Super UserAnonymous , No need to change the date calendar. Change the date in fact
New column =
var _time = timevalue([Datetime])
var _date = datevalue([Datetime])
return
if(_time<time(6,0,0) , _date -1, _date)
Join this new date date column with date table
Thanks a lot amitchandak
It worked 🙂