Moving average of a moving average measure

[ChristianRHouen]

Dear community

I'm having issues with calculating the moving average of a percentage measure which is calculated on 2 moving average measures (that's right, a double moving average).

What I want is this:

Also attached here: WeTransfer

Why?:
Ratio is a strategic KPI of ours. We want to measure the trend by comparing vs rolling 12m avg.

...

Rolling 12m = 
VAR pre6 =
    EDATE ( MAX ( DateTable[Date] ), -6 )
VAR cure =
    MAX ( DateTable[Date] )
RETURN
    CALCULATE (
        [RATIO],
        FILTER ( ALL ( DateTable ), DateTable[Date] >= pre6 && DateTable[Date] <= cure )
    )

Formulas I use to get the ratio (which are all working as intended):

6M Moving avg 1 = 
   VAR pre6 =
       EDATE ( MAX ( DateTable[Date] ), -6 )
   VAR cure =
       MAX ( DateTable[Date] )
var temp_table = FILTER(ALLSELECTED(ExtraLogic), ExtraLogic[date] >= pre6 && ExtraLogic[date] <=cure && ExtraLogic[DifferentDate] <= cure)
   RETURN
       SUMX(temp_table,ExtraLogic[“DATA1”]) 

6M Moving avg 2 = 
VAR pre6 =
    EDATE ( MAX ( DateTable[Date] ), -6 )
VAR cure =
    MAX ( DateTable[Date] )
RETURN
    CALCULATE (
        [“DATA 2”],
        FILTER ( ALL ( DateTable ), DateTable[Date] >= pre6 && DateTable[Date] <= cure )
    )


RATIO = IFERROR([6M Moving avg 1]/[6M Moving avg 2], BLANK())

Can I attach the data?
I would love to - however, it is confidential, so while I would be happy to sh...

[lbendlin]

Please provide sample data in usable format (not as a picture).