Forum Discussion

user023's avatar
user023
Frequent Visitor
3 years ago

Measure on date based on start and end time

Hi, I have data like this.  I would like to have a between date slicer and from the min and max date to take total actual running time.  Also, I would like it to consider the workcenter number (wil...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

user023 , Try a measure like with slicer on independent date table

 

//Date1 is independent Date table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = minx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Value]), filter('Table', 'Table'[End Time] >=_min && 'Table'[Start Time Time] <=_max))