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.
Hello Anonymous ,
Please try this.
SALES BY LOCATION =
AVERAGEX(
SUMMARIZE(
Sheet1,
Sheet1[Item],
Sheet1[LOCATION],
FORMAT(Sheet1[Date], "MMM YYYY"), -- Convert Date to Month-Year format
"Total Qty", SUM(Sheet1[QTY])
),
[Total Qty]
)
Thanks,
Pankaj
If this solution helps, please accept it and give a kudos, it would be greatly appreciated.