Forum Discussion

Micha3lS's avatar
Micha3lS
Icon for Helper I rankHelper I
5 years ago
Solved

Moving Average

Hello I have the following data: For the visualisation the OEE data will be shown by Produktgroup in a Linechart. Now i want to add a moving average for each of the 3 productgroups. I trie...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Micha3lS , You can create a measure like

     

    Moving Average =
    AVERAGEX(values('OEE nach Linie'[productgroups])
    ,
    CALCULATE(sum('OEE nach Linie'[OEE nach Linie]),DATESINPERIOD(
    'OEE nach Linie'[Buchungsdatum],
    LASTDATE('OEE nach Linie'[Buchungsdatum])
    - 14 ,
    DAY))
    )

     

    Seem like this scatter visual, Go and add constant line, in new version there is Fx, click on that and take this measure)

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Micha3lS , You can create a measure like

 

Moving Average =
AVERAGEX(values('OEE nach Linie'[productgroups])
,
CALCULATE(sum('OEE nach Linie'[OEE nach Linie]),DATESINPERIOD(
'OEE nach Linie'[Buchungsdatum],
LASTDATE('OEE nach Linie'[Buchungsdatum])
- 14 ,
DAY))
)

 

Seem like this scatter visual, Go and add constant line, in new version there is Fx, click on that and take this measure)