Forum Discussion
Churn Rate Contracts
Hi all, I want to calculate a churn rate (not sure if I'm using the correct term), but I need the a matrix like the one below. I think the first challenge would be to have the year as a co...
HI GekkeHellie,
I'd like to suggest you do unpivot columns on these date fields to convert them to attribute and value. Then you can directly use calendar table to link converted fields and use attribute fields group and simply write formula to calculate across different date fields.
Unpivot columns - Power Query | Microsoft Learn
Regards,
Xiaoxin Sheng