Forum Discussion
Converty Yearly Customer Subscriptions to Monthly Subscriptions
Hey,
I have an Abonemment-Table including the BUYDATE and a column including the TYPE (MONTHLY/YEARLY). I Want to count the number of active abonemments each month.
First I want to break down the yearly into monthly subscriptions.
E.g. Yearly subscription on 23.11.2018.
So i get an entry on 23.12.2018, 23.01.2019.... etc.
Hope this is clear enough.
Thank you for your help.
1 Reply
Sample data would make this very clear. 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, take a look at these two Quick Measures as I think you want something like them.
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/409365Or perhaps this one:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Revenue-Reverse-YTD/m-p/373185
