Forum Discussion
Split duration into hourly basis and also split dates when the process overflows the next day
Hi All, I have a problem where in need to split the start and end time in hourly basis and find the duration for which the machine was busy, below is the sample data which i have. Preferably need th...
amitchandak
Super User
Super UserDan_SP , This how I have done in past. Might need to try if this approach did not work.
I created an hour table and and then create a new table with help from that
Generateseries(1:24)
add column
hour = time([Value],0,0)
Then follow the same approach in the file(attached after signature) that I have for date. You need to get the hour from this new table to get diff
Hi amitchandak , I tried your suggestions but was not able to get it work, not sure if I did it correctly as your thing is for calculating the day counts. I need to explore still the dax queries.
