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.
Anything related to PowerPivot and DAX Formuale
1 post • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 3 guests