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. ...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    zubairs , You have to try a measure like

     

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

zubairs , You have to try a measure like

 

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