Customer Subscription

Anything related to PowerPivot and DAX Formuale
Posts: 1
Joined: Fri Dec 01, 2017 7:42 am

Customer Subscription

Postby jon999 » Fri Dec 01, 2017 8:15 am


I am trying to work out if a subscription amount has done one of the following:

No change - no change from current month to previous month
New business - did not have a subscription the previous month and current month has a subscription
Upsell - current month subscription is higher than previous month
Downsell - current month subscription is lower than previous month
Churn - current month subscription is zero compare to previous month
Recovered - the subscription has churned and have come back within a year

My data consist of date, subscription and amount. From there I need to work out the monthly movement to then be able to show that movement in one of the above buckets.

I have attached a sample data to show what I need to do using power pivot.

(273.95 KiB) Downloaded 33 times

Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 13 guests