Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need help: average

Hi, 

 

I calculated the amount of items rejected with the following dax: 

Afgekeurde flowpacks = 
COUNTX(Espera; Espera[Index])

This value is filtered with a date filter on the page.

 

I would like to DAX a running average over the last 2 months,

 

Could someone help me out on this?

Need Help

3 Replies

  • gipiluso's avatar
    gipiluso
    Resolver II
    7 years ago

    It should help somethink like:


    Measure:=
    CALCULATE(Afgekeurde flowpacks,FILTER(Date,Date[Calendar Date]>=DATEADD ( 'Date'[Calendar Date], -2, MONTH )))

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi gipiluso,

       

      I used your formula and it gave me the following result.

       

       

       

       

      I believe we must modify it in a way that it calculates the average 'afgekeurde flowpacks' per line over a period of 2 months.

       

      Any clue how? 

       

      • gipiluso's avatar
        gipiluso
        Resolver II
        7 years ago

        I think that the current measure perform the calculation on the 2 month before, in the report you should se the average of the 2 month collapsed in each point.