Dynamic Moving Average based on my selection in Slicer (Months)

[Fiddel86]

Hi there,

can anyone help, to get my goal:

I am trying to build a dynamic moving average line inside my diagram based on the selection of months in a year or between years.

For example:

KPI

I select June 23 to May 24 in "Month Slicer" for showing up 1 year of specific raw data for kpi

Now i want to have a moving average line too, which calculates this timeline, but be dynamic if i change months from June 23-May24 to for example August 23 - September 24.

How can i solve this? 

[v-zhouwen-msft]

Hi @Fiddel86 ,

Perhaps the following dax expression could be used.

DATESINPERIOD function (DAX) - DAX | Microsoft Learn

CALCULATE(
    AVERAGE('Table'[Amount]),
    DATESINPERIOD(
        'DateTable'[Date],
        LASTDATE('DateTable'[Date]),
        -1, 
        YEAR
    )
)

If I'm misunderstanding, please provide simple data and show the expected results as a picture.