Please find my approach in the attached workbook. You need to restructure your data to get the desired result. I just created a calc for one column. You can use the same logic to derive other columns.
Hope it helps.
Churn rate.twbx 13.0 KB
Thank you for this, union is a good idea. I will try it out.