Converty Yearly Customer Subscriptions to Monthly Subscriptions

[dustin1232]

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.

[Greg_Deckler]

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/409365

Or perhaps this one:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Revenue-Reverse-YTD/m-p/373185