Line chart does not show correct measure

Jean_D · ‎08-31-2022

Hello!

I'm having trouble with my column-line chart.

I have a measure thats calculate the average of the last 3 sales periods and this is working perfectly.

My X axis is month period and I have data from jan-2017 to jul-2022. I need to show the last year.

When I use a filter and select only the last year, the first 2 months doesn't show the correct value and its calculate the first month as the first sale however I have more sales before that date.

If I move the filter it is corrected....

This is my code.

AVERAGEX(

DATESINPERIOD('Calendar Table'[Date],MAX('Calendar Table'[Date]),-3,MONTH),

CALCULATE(SUM('Sales'[Sales]),REMOVEFILTERS('Calendar Table'[Month-Year]))

)

Incorrect Values.

Correct Values.

Please I need help, any possible solution

parry2k · ‎08-31-2022

@Jean_D do you have calendar table marked as a date table? Which table you are using to apply the filter for the year ?

✨ Follow us on LinkedIn and to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.