Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Count New Hire Per Month

Hi, I have a table of Headcount that has below fileds and I need to count the new hired per month: Table = Headcount Fields =  Report Effective Date (which is the monthly report date, that change...
Need Help
zinah's avatar
zinah
Regular Visitor
3 years ago

Hi,

Thanks for your suggestion.

I was trying to build the measure that you suggested but this part of the measure is not clear, what do you mean by MAX(Dates[Date])?

As I mentioned in my previous post, these are the fields I have:

 

Table = Headcount

Fields = 

Report Effective Date (which is the monthly report date, that changes every month)

Employee ID

Hire Date

SpaceDad's avatar
SpaceDad
Frequent Visitor
3 years ago

Would you like some help with creating a 'dates' table?

  • zinah's avatar
    zinah
    Regular Visitor
    3 years ago

    That would be great.

    • SpaceDad's avatar
      SpaceDad
      Frequent Visitor
      3 years ago

      Okay. First thing is to find out what the first hiring date is in your dataset. Once you know that, go to the "Modeling" tab, and click "New Table." For example, if the first date in the dataset for “Hire Date” is 09/05/2005 then that is the first date you will need to use.

      In the formula bar you'll type in Dates = CALENDAR(“09/05/2005”, TODAY())

      After you hit the enter key a dates table should be generated that ranges from the first date in the dataset to the current day date.

      From here you will want to go to the “Model” view by selecting it on the left-hand side of the screen. Then create a relationship between the “Dates” table and “Hire Date” in the original dataset.