Forum Discussion
TimeDifference with two times
Hi, Could please help with the calculation here? My measure calculation is trying to subtract the times 'sdate' and 'edate' and below should be 2:10 and its displaying as 3:00 on the card. ...
Anonymous , the first way to take diff is that you create it as column
New column = [Time1] -[time2]
measure optionsmeasure 1 = sumx(Table, Table[Time1] -Table[time2]) //you can use averageX
calculate( min(Table[Time1] ) -max(Table[time2]) , values(Table[ID])) // force row context, but Gt will wrongrefer for row context
Anonymous , the first way to take diff is that you create it as column
New column = [Time1] -[time2]
measure options
measure 1 = sumx(Table, Table[Time1] -Table[time2]) //you can use averageX
calculate( min(Table[Time1] ) -max(Table[time2]) , values(Table[ID])) // force row context, but Gt will wrong
refer for row context
Thankyou amitchandak as always 🙂