Forum Discussion
Need help in calculating date difference in following
In this data I need to calculate date difference System.changed date. We are given with ID along with rev which is order of System.State change. Suppose we are having first ID 1049352 , for this ID , rev=1 i.e state is new and rev=13 when it is first time done. So we need to calculate date difference [( rev=13 Done)-(rev=1 New)]. Then similarly we have to go for next ID. Please help.
2 Replies
- amitchandak
Super User
Anonymous , Try a measure like
AverageX(Summarize(Table, Table[ID], "_1", Minx(filter(Table, Table[System.state]="New"), [System.Createdatetime]), "_2", Minx(filter(Table, Table[System.state]="Done"), [System.Createdatetime])), datediff(_1,_2,day))
