Rolling 12 months average

Question

Hello,&nbsp;I sued a "quick measure" to colculate the rolling 12 months average, but it does not look quite right and goes into the future months for some reason. Can some please help me?&nbsp;p.s. I have a Date Hierarhy applied on my "Date" column.&nbsp;&nbsp;&nbsp;&nbsp;

tackytechtom · Answer

Hi&nbsp;AndreOlha&nbsp;
&nbsp;
Does it work with something like this?
MovingAverage = 
CALCULATE (
    AVERAGE ( Table[GJ] ),
    DATESINPERIOD (
        'Table'[Year - Month],
        STARTOFMONTH ( LASTDATE (   'Table'[Year - Month] ) ),
        -12,
        MONTH
    )
)
Let me know if this helps! Feel free to share your file, if the above does not work and I am happy to support you!
&nbsp;
/Tomhttps://www.tackytech.blog/https://www.instagram.com/tackytechtom/

andreolha · Answer

Hello&nbsp;tackytechtom&nbsp;thank you so much for your reply and help!I plugged in your formal and it solved the problem with showing the future months, however the rolling average it is equivalent to my data values (please see the screenshot for more detail).My data values are shown as "average" so it might have to do something with, right? It was my another issu I did not how to show my data value no agrregated ot averaged just as it is. All of my data value columns are categorized as "Whole numbers" and "Nor summarized".Hope I am making some sense 🙂&nbsp;Thank you for the help.&nbsp;&nbsp;

andreolha · Answer

tackytechtom&nbsp;The movement that is shown below is the right one with respect to the data points and the rolling average (old formula used) but the problem here is the yellow area which shows future project months.&nbsp;&nbsp;

tackytechtom · Answer

Hi&nbsp;AndreOlha&nbsp;,
&nbsp;
Now, I had time to look into it.&nbsp;
&nbsp;
Try the previously suggested solution (Note, it should be STARTOFMONTH and not EOMONTH in the formular), and then you select the following settings in your graph:
&nbsp;

&nbsp;
Does this solve the&nbsp;issue? 🙂
&nbsp;
/Tomhttps://www.tackytech.blog/https://www.instagram.com/tackytechtom/

ashish_mathur · Answer

Hi,
Ensure that you have a Calendar Table with calculated column formulas for Year, Month name and Month number.&nbsp; Sort the Month name by the Month number.&nbsp; Create a relationship (Many to One and Single) from the Date column in your Data Table to the Date column in the Calendar Table.&nbsp; To your visual, drag Year and Month name to the X axis.&nbsp; To get help with the mesures, share the download link of your PBI file.
&nbsp;

Forum Discussion

Rolling 12 months average

7 Replies

Related content

12 Month Rolling average.

Rolling average last 3 months

rolling 12 month average

Rolling 12M Average measure

Rolling 12 Month Average