Forum Discussion
Ageing analysis in the same column
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 |
1 Reply
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)
