Monthly Revenue

[Ahmad_AI]

Hello Dears, 

I have a table that contains the client subscription, and I want to know the MMR for each month. So if the client subscription falls within two months, I need the amount to be divided over the two months however the subscription will be divided over the dates.

In this way, I can know the revenue for each month. 

Any Idea, dears?

Regards

[Ahmad_AI]

Hello @Greg_Deckler ,

Thank you for your reply; this is a useful file that will help to identify the sales where it falls over the ranges; however, I want to divide the amount over the number of days for the subscription. 

For example: if I have a subscription that falls in three months, let's say 15 of Sep to 15 of Nov and I need to know the total MRR for each month, so I need to calculate for each month only the amount that falls in and I can't calculate the full amount for the first 15 days. 

[Greg_Deckler]

@Ahmad_AI Post your sample data as text as well as your expected output. Otherwise it is nearly impossible to provide a specific answer. 

Please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, 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

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Ahmad_AI]

Hello @Greg_Deckler ,

Sorry for being late; please find the attached sample. 

https://docs.google.com/spreadsheets/d/1rFra3yyAqJmMkctl57NnsLGl8nb9JzFs/edit?usp=sharing&ouid=11653...  

[Greg_Deckler]

@Ahmad_AI I've done some things like that:

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

Maybe this one as well: Blowout! - Microsoft Power BI Community