Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
@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 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
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |