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.

     

v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
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

suegee's avatar
suegee
Regular Visitor
7 years ago

Thanks Cherie,

 

The only way I could get this to work is if I added second date calendar that had just 2017 dates in it, so that it could be the max and then it would work.   Not sure if that's the right way to do it.