Average quarter data by month

sssssssssssssss

I think I got it.

This is the measure:

Avg by Q = 
	CALCULATE(
		SUM('Quarter'[USD Net Rev])/3,
		ALLEXCEPT('FiscalYMD', 'FiscalYMD'[Year Quarter]),
		VALUES(FiscalYMD[Year Quarter] )
	)

I also added two columns Year Month and Year Quarter to your date table:

Year Month = FiscalYMD[Year] & "-" & format(FiscalYMD[Month], "00")

Year Quarter = FiscalYMD[Year] & " Q" & FiscalYMD[Quarter]

Then it looks like this: 

Because I use VALUES of the quarters in the measure you can leave the quarters out of the table.

Here is the link to your file.

It works with me...