Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 thi...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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))

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Amit thanks for solution . I am trying this solution. If I get any difficulty in implementation I will get back to you. Thanks a lot