Forum Discussion
Calculating Average by multiple columns
Hi All,
I am trying to calculate average based on multiple column. Would have used AverageIfs in excel for this calculation.
Example:
Average Revenue by "FY Quarter, Month, City and product" and then calculate "Max Sales by FY quarter, Month and city" and finally calculate difference between "Max Sales by FY quarter, Month and city" and "FY Quarter, Month, City and product" in percentage. Based on high percentage of revenue need to get "Product" name as recomendation to taget.
Can any one help on how to do this in powerbi.
Regards
Sriram
2 Replies
- amitchandak
Super User
skolathu , Assume you sum values and then table Avg, then you can try measure like. Same is true for Max /min etc
AverageX(summarize(Table, Table[Month Year], Table[product], "_sum", calculate(Sum(Table[Value])) ) , [_sum])
v-xiaotangCommunity Support
Hi skolathu
Thanks for reaching out to us.
How to convert AVERAGEIFS to dax code, please refer to this post https://community.powerbi.com/t5/DAX-Commands-and-Tips/AVERAGEIFS-in-dax/td-p/2653698
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
