Consecutive status count

I have a table with the status of my clients of all the months, what I would like is to be able to make a measure to calculate how many average months they last with x status, either active or inacti...