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 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)