# Power BI Exchange

View Only

• #### 1.  How to calculate future revenue

Posted 16 days ago
Edited by Klaus T 16 days ago
Hi

I want to calculate/estimated the revenue the first 4 month after a deal. It is lower the first 4 month.

 Invoicing MRR 7. WON Mth 1 Mth 2 Mth 3 Mth 4 Case 1 10,000 10/31/2022 0% 25% 75% 100% 0 2,500 7,500 10,000 Mth 1 Mth 2 Mth 3 Mth 4 Case 2 25,000 11/30/2022 0% 25% 75% 100% 0 6,250 18,750 25,000 Invoicing Oct Nov Dec Jan Feb Mar Case 1 0 0 2,500 7,500 10,000 10,000 Case 2 0 0 0 6,250 18,750 25,000 Total 0 0 2500 13750 28750 35000 Contract signment

I know the monthly revenu and contrract date at contract signment, and then I want to calculate MR the next 4  month for all won cases.

How to?

------------------------------
r
------------------------------

• #### 2.  RE: How to calculate future revenue

Posted 11 days ago

Hi Klaus,

What do you mean by MRR?

The data presentation is quite confusing as how you distribute the MRR of 10,000 in case 1. The value in revenue exceed 10,000 from Dec-Mar i,e, 2.5K + 7.5K + 10K + 10K = 30K.

Rd

------------------------------
Senior Finance Analyst
------------------------------

• #### 3.  RE: How to calculate future revenue

Posted 11 days ago
Edited by Klaus T 11 days ago
Hi

Sorry. MRR means Monthly Revennue in the contract period.

In case 1 the monthly revenue is 0% (0), 25%(2.5K), 75%(7.5K) and 100%(10K) in the first 4 month. After that it is 100%(10K) per month.

I hope that helps with the confusion. :-)

• #### 4.  RE: How to calculate future revenue

Posted 11 days ago

Hi,

For how long the monthly revenue will exist? Let say case 1, you have 1st 4 months but there is still a value on 5th month? When it will stop?

------------------------------
Senior Finance Analyst
------------------------------

• #### 5.  RE: How to calculate future revenue

Posted 11 days ago
Edited by Klaus T 11 days ago
Hi

In month 5 to 12 it is 100% per month , and then it will stop.

/

• #### 6.  RE: How to calculate future revenue Best Answer

Posted 11 days ago

Hi,

You can directly work on power query to generate the series required. Check the attached file and view it in power query and check the query steps.

Rd

------------------------------
Senior Finance Analyst
------------------------------

Attachment(s)

MRR_01.pbix   72 KB 1 version

• #### 7.  RE: How to calculate future revenue

Posted 11 days ago
Edited by Klaus T 11 days ago
Hi

Brilliant, fantastic.

Thank you. :-)