cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Phaneendra
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.

 

Phaneendra_0-1622070094941.png

Let me know if I can get this revenue.

Regards

Phaneendra

 

5 REPLIES 5
v-deddai1-msft
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

@v-deddai1-msft 

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.

 

Regards

Phaneendra
Frequent Visitor

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

 

Phaneendra_0-1622070361910.png

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!