Count distinct lead id when the status changes from A to B

[rohit18]

Hi all,

wanted to count the distinct Lead_id when it changed it state from qualified to Inactive.

attached image for refrence 

[amitchandak]

@rohit18 ,  You can have a flag column like

New column =

var _date = maxx(filter(Table, [ID] = earlier([ID])  && [Date] < earlier([date]) && [Change] = "Qualified") , [Date])

return

if( [Change] = "Inactive" && not(Isblank(_date)) ,1, 0)