Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 if that makes sense. I treid a measure I have used before with success although I previously used it as days not months and I tried a measure I found on here that was for someone else that had the same question. below is the two measures I have tried and screenshots below.
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.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
8 | |
8 |
User | Count |
---|---|
13 | |
12 | |
11 | |
10 | |
8 |