Forum Discussion

japolo's avatar
japolo
Frequent Visitor
3 years ago

Rows or values present between two row values

Hi, I've ran into a question that seems complicated to decipher. I have a dataset where an initiated session has multiple rows, where every action is in sequential order. What I want to look at is t...
Need Help
v-xiaotang's avatar
v-xiaotang
Icon for Community Support rankCommunity Support
3 years ago

Hi japolo 

Thanks for reaching out to us.

you can try this

Difference = 
var _id1=MINX(FILTER('Table','Table'[label]="planner2d"),[sequence_nbr])
var _id2=MINX(FILTER('Table','Table'[label]="planner3d"),[sequence_nbr])
return _id2-_id1-1

 

 

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.