calculating run rate to dynamically change

All, 

I have a measure I'm using that helps me obtain Average Monthly Revenue for the current year - and automatically adjusts the value by recalculating when a month closes. So if avg monthly revenue on July 10th shows 500,000 (based on Jan-Jun), when July ends, the value recalculates to include 7 months and adjusting the value to say 525,000 per month in the current year. 

The DAX I'm using is:

DIVIDE(CALCULATE(SUM('Acctg Revenue'[Revenue]), FILTER('Acctg Revenue', 'Acctg Revenue'[Date] < EOMONTH(TODAY(),-1))) , (MONTH(TODAY())-1), 0)

I now want to do some forecasting, so I brought in my table which has numbers for Principal accounts to include forecasted and actual values. If I have actual revenue in through June of 2024 for each principal, I want to calcuate the monthly runrates for July through December for these principals.

The typical formula I would use in Excel would be =sum(cell of each principal monthly value/6) * 12 = runrate. Where 6 is the number of months I have actual data on.

This would project my potential for the remainder of the year. When July closes, the 6 in the equation would change to 7, then recalculate to project remaining 5 months to help give an overall yearly projection of revenue.

Is there some way I could achieve this result and to automatically have it adjust so when the month closes it would change (i.e. from 6 to 7). I think it may have something to do with the expression from the DAX measure I mentioned earlier - Average Monthly Revenue for the current year - < EOMONTH(TODAY(),-1.

I also have a column in my data called Revenue Type, which includes two types - Actual and Forecast, so not sure how to ensure that only Actual is part of the measure. If I pulled the measure into a table I  would want it to show a run rate for any line where status shows Actual and nothing for any line that shows status of Forecast.

Taking the DAX measure from Average Monthly Revenue for current year (noted above)...I've modified it a bit, however I'm not sure how I include the Principal (or if it is necessary to do that) to ensure this calculates only for each principal. And as noted above, I need to somehow include that this is only for anything where Revenue Type is = Actual.

DIVIDE(CALCULATE(SUM('Forecasting'[Revenue Amount]), FILTER('Forecasting', 'Forecasting'[Date] < EOMONTH(TODAY(),-1))) , (MONTH(TODAY())-1), 0)

Hope someone can help?