Calculating Average by multiple columns

[skolathu]

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

[v-xiaotang]

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.

[amitchandak]

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