Help Needed with Calculating Percentages Based on Date Fields in QuickSight

Hi @mintomichael,
Sorry for the delayed response!
So to understand your dataset a bit further, I’m guessing a row consists of a customer, and then there are columns/fields for expiration month, effective month, etc?
Could you share the calculated fields you’re using to get the available and renewed numbers?

Alternatively, if able to, this could be easier to assist if you upload a copy of your analysis with sample data to the QuickSight Arena view, that way I could test out a couple different scenarios to see what may work!