Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Guys,
I need to calculate the revenue from below format data, I have plan start date and end date is always 31/12/9999, by requirement is if a customer started on Jan 1st, record shows as 1/1/2021 to 31/12/999 with quntity and rate, I need calculate Mly, Qly, Hly, Yly revenue. Below is the screen shot.
Let me know if I can get this revenue.
Regards
Phaneendra
Hi @Anonymous,
Would you please show me more information about how to calculate revenue in your sample. I don't have much knowledge about it.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @Anonymous ,
How do calculate monthly qtrly yearly revenue? (Qty * rate) /12?
Best Regards,
Dedmon Dai
so, let me give you a simple example for understanding.
eg: we have 3 clients who pay 25$ per month and C1 started on 1/1/2021, C2 started on 1/2/2021 and c3 started on 1/3/2021.
in this case on 31/3/2021 my reveune will be 75+50+25 = 150
and in Q2 it will be 25*3(clients)*3(months) = 225
and if the user selects half then it will be 150+225 = 375
in simillarly Yly and Mly, Prev ylr or in selected time period.
Regards
I have a data range too, as per selected data range I need revenue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |