Forum Discussion

Danyal's avatar
Danyal
Regular Visitor
3 years ago

Row based time calculation

Good Day everyone   I need a measure where i can show hours/mins 1 customer took from one to another move?         data_source_veiw P_ID      Customer            Move_Name    Move...
hour between rows
Danyal's avatar
Danyal
Regular Visitor
3 years ago

HI SamInogic ,

 

Thank you so much for helping out.

 

the provided measure seems fine but i doubt one thing, lets say one Move has 3 or more ids as one move will go under sevaral moves, so the goal is to calculate hours or minuts that a customer has spent in each move or from one to another move.

so the ultimate result would be i will create 2 slicers to select desied moves and it will show the hours or mintus that customer and move has taken.

 

thanks again for your input.

😊