Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

3-year rolling average issue

Hi, I have two tables: 1. Date table 2. Table containing data on sorting analysis of residual household waste. We look at this to determine the recycle potential. This table contains the percentag...
Anonymous's avatar
Anonymous
Not applicable
1 year ago

This is another measure I have tried, but this just gives me the yearly average rather than a 3-year RA:

VAR Jaargemiddelden = 
    SUMMARIZE(
        'Sorteerproeven data SharePoint List',
        Datum[Jaar],
        "JaarGemiddeldeDeelstroom", [Yearly average per subcomponent]
    )
RETURN
    CALCULATE(
        AVERAGEX(Jaargemiddelden, [JaarGemiddeldeDeelstroom]),
        DATESINPERIOD(
            'Datum'[Date],
            MAX('Datum'[Date]),
            -3,
            YEAR
        ),
        ALLEXCEPT('Sorteerproeven data SharePoint List', 'Sorteerproeven data SharePoint List'[Grouping components Residual], 'Sorteerproeven data SharePoint List'[Component], 'Sorteerproeven data SharePoint List'[subcomponent])
    )