Forum Discussion

zubairs's avatar
zubairs
Icon for Helper I rankHelper I
5 years ago
Solved

Calculate average from text column using month as base.

I have a report from HR that has the ID for each employee.

 

In order to get the total number of HC, I am taking the count of employee ID. This works fine when I'm applying filter for a one month.

 

The problem occurs when I'm selecting multiple months because the count measure adds both months. Whereas, I want it to get the average of the two months.

 

 

Any suggesstions?

 

1 Reply

  • zubairs , You have to try a measure like

     

    averageX(values(Date[Month]), [Count of employee])