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.
Hi,
Why are you creating a calculated table formula? Why are you not writing measures in a visual? Share some data to work with and show the expected result. Share data in a format that can be pasted in an MS Excel file.
Hi Ashish,
It makes sense to use measure if I don't need a new table
How would I do that ?
Below is the data
LOCATION Item QTY SALES Date month A K110 2 200 01/02/2025 2 B K110 5 500 01/01/2025 1 A K110 3 310 05/01/2025 1 A K110 15 1500 08/03/2025 3 B K110 2 4000 01/02/2025 2 B K110 10 1000 09/02/2025 2 B K110 5 500 07/03/2025 3 B K200 4 335 06/02/2025 2 A K200 4 335 04/02/2025 2 B K200 8 640 06/03/2025 3 A K110 10 1200 12/03/2025 3 A K200 6 487 15/02/2025 2 B K200 7 572 28/02/2025 2 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)
Show the expected result very clearly.
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)