Revenue Formula

[Anonymous]

I have this table:

We have a strange way of calculating our revenue... In order to project our revenue for the future for each company, what we have to do is get the revenue total from two months prior and multiply that total by 12. So in plain terms for March it would be:

(Sum of Revenue from January by Delta Account) * 12

So as each month progresses (since this is dynamic data) the formula would look back to Feburary totals for April once April is here, March totals for May once May is here, etc.

How would I go about setting that up?

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

Maybe this formula will help.

Measure =
CALCULATE (
    SUM ( Table1[Revenue_Amount_c] ),
    DATESINPERIOD ( 'Calendar'[Date], MAX ( 'Calendar'[Date] ), -3, MONTH )
)
    * 12

Best Regards,

Dale