Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

How do I get Mly, Qly, Hly, Yly revenue in this case?

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.




Community Support
Community Support

Hi @Phaneendra,


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


Its (Qty * rate) per month

Hi @Phaneendra ,


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.



Frequent Visitor

I have a data range too, as per selected data range I need revenue.




Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.