Average count in each month
Hi, I tried to calculate the average of number of employee in each month. Here's the example of my data, there is no duplicate of employee id in each month. The result i would like to see using Matrix visualization is in the red box from the second month and so on, the formula in my excel looks like this =AVERAGE($E$2:F2) F2 will change based on month, (G2 in march / H2 in april so on and so forth) I've tried the averagex AVERAGEX ( VALUES ('HR Report 2023'[Month]), CALCULATE ( COUNT ( 'HR Report 2023'[Employee ID])) , however it only retuned the average in total (6), but I would like to see the average in each month. And the result from the average will be the denominator to calculate the attrition. Please help me. *Sending appreciation in advance* and thank you a lot.
