3 Month Average

Question

Hello hopefully a quick one.&nbsp;For some reason my three month calculation is returning a strange number and I havent been able to correct it.&nbsp;&nbsp;Result is shown below and the formula I am using is the below.&nbsp; Im sure it is a basic fix but I am missing it.&nbsp;Last 3 Month Average = AVERAGEX(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATESINPERIOD('Mapping Month'[Registration Date ],&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; max('Mapping Month'[Registration Date ]),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -3,MONTH)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Total Retails])ThanksSimon

migasuke · Answer

Hi SimonC1988Help ,Try to adjust the formula as I did in my formula using CALCULATE and AVERAGE:One note - I am using date , don't know if you have dates or just months, this can be crucial.&nbsp;&nbsp;&nbsp;&nbsp;

simonc1988help · Answer

thanks for the reply&nbsp;Migasuke&nbsp; thisis my mapping table for month. This maybe is where I am going wrong.&nbsp;and unforunately looks like i lose my data when i change to the fomrula you wrote.&nbsp;ThanksSimon&nbsp;

migasuke · Answer

Can you send me screenshot of your relationships in Model section?I want to see how your Mapping Month connected.&nbsp;

Forum Discussion

3 Month Average

3 Replies

Related content

Rolling average last 3 months

Rolling 3 month average - 3 months

Average of 3 Months

Top 3 Average Sales mix

Calculating average 12 month average