Forum Discussion
Using AVERAGEX ON SUMMARIZE DATA
Hi, I am relatively new to PowerBI and DAX and trying to build a sales report. and would greatly appreciate some help with trying to get an AVERAGEX formula to work. I am trying to calculate ...
Hi,
PBI file attached.
Hope this helps.
Also here is an example of an expected result. I would expect the average qty of item K110 at location A to be 10 (2+3+15+10)/ 3 (data spans 3 months)
Hi,
PBI file attached.
Hope this helps.
Thank you very much Ashish- this measure works. I appreciate your assistance.
You are welcome.