Monthly Average of Total run rate

[Anonymous]

I am needing to know if it is possible to calculate the average of the total run rate based on the month number. 

If you see below i am needing the last column divided by month.  In Februrary it would be 47,345,465/2.

Invoice Amount running total in Month = 
CALCULATE(
	SUM('Invoices'[Invoice Amount]),
	FILTER(
		CALCULATETABLE(
			SUMMARIZE(
				'Invoices',
				'Invoices'[Approved by Date].[MonthNo],
				'Invoices'[Approved by Date].[Month]
			),
			ALLSELECTED('Invoices')
		),
		ISONORAFTER(
			'Invoices'[Approved by Date].[MonthNo], MAX('Invoices'[Approved by Date].[MonthNo]), DESC,
			'Invoices'[Approved by Date].[Month], MAX('Invoices'[Approved by Date].[Month]), DESC
		)
	)
)

[Anonymous · Accepted solution]

Here is the Dax that I wrote to get the cummulative monthly average per year.

Cummulative Avg = DIVIDE(Invoices[Invoice Amount running total in Month],CALCULATE(AVERAGE(Invoices[Approved by Date].[MonthNo])))

[amitchandak]

@Anonymous ,

Cumm Sum = CALCULATE(SUM('Invoices'[Invoice Amount]),filter(allselected(date),date[date] <=max(date[Date])))

or

Cumm Avg = CALCULATE(SUM('Invoices'[Invoice Amount]),filter(allselected(date),date[date] <=max(date[Date])))/CALCULATE(distinctcount(Date[Month-Year]),filter(allselected(date),date[date] <=max(date[date])), not(isblank('Invoices'[Invoices Amount])))) 

or

Cumm Avg=

var _1 = averagex(values('Date'[Month]) , calculate(SUM('Invoices'[Invoice Amount])))

return

CALCULATE(_1,filter(allselected(date),date[date] <=max(date[Date])))