Forum Discussion
Solved
Finding Average based on multiple criteria
Hi every one, I'm trying to write a formula based on multiple conditions as per stated below. Location Designation Department Rate / Hour IND Data Analyst A 10 IND Data Analyst B ...
Here is a simple formula solution:
In E2:
=AVERAGEIFS($D$2:$D$6,$A$2:$A$6,A2,$B$2:$B$6,B2)
For DAX (Power Pivot)
Average Rate measure:
=CALCULATE ( AVERAGE ( Table1[Rate / Hour] ), ALL ( Table1[Department] ) )