MRR & ARR Calculation

[paulfink]

hi guys,

need a hand calculating MRR and ARR.

i have a sales table that has sale name - client - sale date - sale amount

we want to see the recuring revenue by month and by the year as we have fixed sale amounts.

we require:

1. Expansion: When a current client ups the sale amount because of more services included in the package.
2. Reactivation: Revenue from a client that had previously used and paid for our services.
3. Contraction: Lost revenue from existing clients that have begun to pay less because of removal of services in a package
4. Churn: Revenue lost from cancellations

how will i be able to calculate this for MRR and ARR?

[v-shex-msft]

Hi @paulfink,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak]

@paulfink , there require some duration to calculate

example

Customer Retention Part 1:
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/b...
Customer Retention Part 2: Period over Period Retention :https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retenti...

https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-5-Year-on-Year-Retention/ba-...

Customer Retention Part 5: LTD Vs Period Retention
https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-5-LTD-and-PeriodYoY-Retentio...