Ageing analysis in the same column

[tnarenderr]

Need ageninge analysis for ord 1 agenig of dispatched is 4 days (dispatcehd date - Ordered date)

please help me for the belwo samaple data

Order ID	Order Date	Status	Ageing in days
Ord 1	8/11/2022	Ordered
Ord 1	8/15/2022	Dispatched	4
Ord 1	8/19/2022	Delivered	4
Ord 2	9/10/2022	Ordered
Ord 2	9/12/2022	Dispatched	2

[amitchandak]

@tnarenderr ,

Try a new column like

=

var _max = maxx(filter(Table, [Order ID] = earlier([Order Id]) && [Date] < earlier([Order Date])) , [Order Date])

return

datediff(_max, [Order Date], day)