Dax Formula

Hi u201600699,

Did you mean to get values from three month ago? If that is the case, you can extract the current date as variable to get the previous value based on current category groups.

3M Ago =
VAR currDate =
    MAX ( Calendar[Date] )
RETURN
    CALCULATE (
        SUM ( Table[Value] ),
        FILTER (
            ALLSELECTED ( Table ),
            [Date]
                = DATE ( YEAR ( currDate ), MONTH ( currDate ) - 3, DAY ( currDate ) )
        ),
        VALUES ( Table[concepto] )
    )

I’m not so clear how the persistence of six values calculated, here is the measure formula to get the difference between current three month ago value and rolling six month fact value averages, you can try it if help:

Diff =
VAR currDate =
    MAX ( Calendar[Date] )
VAR threeMonthAgo =
    CALCULATE (
        SUM ( Table[Value] ),
        FILTER (
            ALLSELECTED ( Table ),
            [Date]
                = DATE ( YEAR ( currDate ), MONTH ( currDate ) - 3, DAY ( currDate ) )
        ),
        VALUES ( Table[concepto] )
    )
VAR summary =
    SUMMARIZE (
        FILTER (
            ALLSELECTED ( 'Table' ),
            [Date]
                >= DATE ( YEAR ( currDate ), MONTH ( currDate ) - 6, DAY ( currDate )
                    && [Date] <= currDate )
        ),
        [Date],
        [concepto],
        "current Value", SUM ( 'Table'[Value] )
    )
VAR AVG =
    AVERAGEX ( summary, [current Value] )
RETURN
    DIVIDE ( threeMonthAgo - AVG, AVG )

Regards,

Xiaoxin Sheng