I have to compare the individual expense of the employee to the average of all the employees of that level. I have 4 levels. How to write a calculated field for that?
1 answer
Hello shubhrika,
It's difficult to provide advice without knowing the data format.
Please attach a sample workbook (Packaged workbooks and flows: when, why, how ) or sample data.
Here's example using superstore sample data, comparing average profit by sub-category to average profit by category.
The calculation for comparison is,
AVG([Profit]) / AVG({ EXCLUDE [Sub-Category]: AVG([Profit])})
Regards
Lei
