Forum Discussion

suegee's avatar
suegee
Regular Visitor
7 years ago
Solved

Employee Count based on Hire/Rehire date

Hi,  I am new to Power BI and tried to find something that was similar to what I was trying to do.  I didn't have much luck on this and appreciate any assistance.  I have data that has unique employe...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi suegee

     

    You may refer to below measure. 

    Measure  =
VAR currentDate =
    MAX ( Data[Date] )
RETURN
    CALCULATE (
        COUNTROWS ( EE_List ),
        FILTER ( EE_List, EE_List[Year] = 2017 && EE_List[Date] <= currentDate )
    )

    Regards,

    Cherie

  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    You may download my PBI file from here.

     

    Hope this helps.

     

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

What do you mean by "all the way back to the first higher"?  Do you mean to start counting from the very first date in your dataset?

suegee's avatar
suegee
Regular Visitor
7 years ago

Hi Ashish_Mathur,

 

That's correct. Count the datasets from the first date. But keeping in mind that I want to take Jan 31 2018 and add this date to all previous dates to when someone was first hired, ie.  Jan 31, 2018 - May 13, 1998 and have that count as the number of actives for Jan 2018.  Feb 2018 would be Feb 28, 2018 inclusive to May 13, 1998.   Jan 30, 2017 would include Jan 30, 2017 back to May 13, 1998.   Does that help figure out what I am doing?

 

thanks for your help,

Sue

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

     

    You may download my PBI file from here.

     

    Hope this helps.