Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

DAX

Hi, I am truly sorry if this question has been asked before but I can't seem to find the answer in the internet.   I have a table in a direct query mode that is populated everytime someone send a r...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try a new measure like

 

Duration =
datediff( max(Table[Event Date]), calculate(max(Table[Event Date]), filter(allselected(Table), Table[Vessel ID] = max(Table[Vessel ID]) && Table[Event Date] < max(Table[Event Date]))), day)

 

 

or

 


Duration =
sumx(ADDCOLUMNS(summarize(Table,Table[Vessel ID],[Event Date]), "_1" datediff( max(Table[Event Date]), calculate(max(Table[Event Date]), filter(allselected(Table), Table[Vessel ID] = max(Table[Vessel ID]) && Table[Event Date] < max(Table[Event Date]))), day)),[_1])