3-year rolling average issue

Hi Anonymous 

Please try this measure:

3-year rolling average per subcomponent =
VAR _CurrentYear =
    YEAR ( MAX ( 'Datum'[Date] ) )
VAR Jaargemiddelden =
    SUMMARIZE (
        'Sorteerproeven data SharePoint List',
        Datum[Jaar],
        "JaarGemiddeldeDeelstroom", [Yearly average per subcomponent]
    )
RETURN
    CALCULATE (
        AVERAGEX ( Jaargemiddelden, [JaarGemiddeldeDeelstroom] ),
        FILTER (
            ALLSELECTED ( 'Datum' ),
            YEAR ( 'Datum'[Date] ) <= _CurrentYear
                && YEAR ( 'Datum'[Date] ) >= _CurrentYear - 3
        ),
        ALLEXCEPT (
            'Sorteerproeven data SharePoint List',
            'Sorteerproeven data SharePoint List'[Grouping components Residual],
            'Sorteerproeven data SharePoint List'[Component],
            'Sorteerproeven data SharePoint List'[subcomponent]
        )
    )

Hope this can help.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.