DAily average by product and day

[pedroccamaraDBI]

Hello all
I have this stocks table to get the daily average by product.

And what i am asking you guys, what's the right way to calculate this daily average by product.
Thank you all in advance
Best regards

[ValtteriN · Accepted solution]

Hi,

You can use the basic AVERAGE function it will change its values based on you filter. So AVERAGE(Table[Column]). Also you might benefit for using table visuals built in average aggregation.

Example:

Measure 16 = AVERAGE(AverageItem[Column1])

Ping me with @ if I missed your goal.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

[pedroccamaraDBI]

Hi @ValtteriN 
I believe you're right. I lost a lot of time with AVERAGEX(VALUES(Dates[Date]),[Stock]) and with KEEPFILTERS instead of VALUES but also a simple DIVIDE (Stock, countrows (Dates)). At the end, maybe because this is not a table with a record per day, your solution is the one, AVERAGE ( Table[column]).
Thanks a lot Valtteri