Can I build a visual suited to showing ongoing recurring payments for a customsubscription purchased

[LornaR]

Would anyone be able to advise if I can build something in Power BI which allows me to show the initial subscription sales per month in one column but then show recurring payments month on month, relating back to the initial sales month so it can be viewed month by month where drop off might be occurring.  I'm new to Power BI so have got my measure to show sales per month ok, but haven't got a clue on how to go about showing the ongoing recurring subscriptions relating back to each month? Appreciate any help

[amitchandak · Accepted solution]

@LornaR , while I need sample data to suggest. This blog can help you how to do that

Customer Retention Part 3: Period Of Stay – Cohort Analysis: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-3-Period-Of-Stay-Cohort-Anal...

[LornaR]

Thanks for this, I actually found another couple of methods which seems to work well when sliced by month so good to know there are lots of options!

Pay2 = COUNTROWS(filter(SUMMARIZE('Stripe Sales', 'Stripe Sales'[customer_id], "count", countrows ('Stripe Sales')), [count] > 1))

and

Pay2V2 = Calculate(DISTINCTCOUNT('Stripe Sales'[customer_id]), 'Stripe Sales'[description] = "Subscription Update")