Forum Discussion

evadung's avatar
evadung
Frequent Visitor
3 years ago
Solved

Moving average excluding days without data

Hello,    I have this chart with moving average. I dont want to see 4th and 5th day because theres no data (theres more date without data, 4th and 5th is for example). I have no clue what to do. ...
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    Moving average % =IF( [Produktivität],

    averagex(
        FILTER(ALLSELECTED(Kalender),
        Kalender[Datum] <= MAX(Kalender[Datum])),
            [Produktivität]))
wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

Moving average % =IF( [Produktivität],

averagex(
    FILTER(ALLSELECTED(Kalender),
    Kalender[Datum] <= MAX(Kalender[Datum])),
        [Produktivität]))
evadung's avatar
evadung
Frequent Visitor
3 years ago

Works! Thank you!