Forum Discussion

rflipper's avatar
rflipper
Frequent Visitor
7 years ago

MRR Churn calculation

    Hello!  I have a simple model with the following structure:  Date | Subs | Income   I have the following code to calculate MRR for new customers.  MRRNew = IF( ISFILTERED('transactions'[...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Sample data and expected results would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

That being said, see if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008

 

It should help you get the values for current month and last month. Also, you might be looking for some time interval stuff, you can find that here:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365