Forum Discussion

OhLookAnError's avatar
OhLookAnError
Icon for Helper I rankHelper I
2 years ago

Rolling trailing 12 month average

Hey everyone, this seems simple and I have got it to work before but I cant seem to get it to work in this case.    I just need the line to be the average of the last 12 months at each column point...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi OhLookAnError ,

 

Based on the information you provided, I am not sure what kind of error you encountered during the process. What is your reported error, can you attach a screenshot of the error or provide a pbix file without privacy?

 

Here is the version of my Power BI Desktop:

 

 

Below is the screenshot and pbix file of my reproduction:

 

 

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

 

Best Regards,

Yifan Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • OhLookAnError's avatar
    OhLookAnError
    Icon for Helper I rankHelper I
    2 years ago

    Thanks for the response! To clarify, I am not getting an error, it just isnt returning the avaergae of the prior 12 months. The value just goes up and down correlating directly to each month instead slighter changes to represent the average.