Time Sensitive project count

Below is a table of data on a few projects. Anytime a projects changes hands, a new line item in added with the date and the stage associated.   My question is how can I create a meaure that looks ...