how to count policy which has prior Job type as Reinstatement
I am not able to firgure it out
If you are looking for count of policies against specific job type, here is the syntax.
PolictCountReinstatement = CALCULATE(DISTINCTCOUNT(Table1[PolicyNumber]),Table1[JobCloseDate]<=VALUES(Table1[JobCloseDate]),Table1[Job] ="Reinstatement")
What will be sorting order? If date, you can have multiple policies within same date. To find context to previous value we need to sure about the data sorting order.
lets say the order of sorting would be Primary jy which is an identity column(1,1)