Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Employee Turnover

Hi all,   I am new to powerbi / data modelling and need to prepare a headcount & turnover rate report.   My data like below: Team Member List - Each employee only have 1 row in the Employee Dat...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Daniel,

 

Thanks for your suggestion in advance.

 

May i ask a stupiad question thay is PowerBI calculation same as PowerPivot in Excel?

 

Beg HC 4:=CALCULATE(TeamMemberList[Employee ID],filter(TeamMemberList,[Last Hire Date]<=MIN('Calendar'[Period Start Date])&&([Last Employment Date]=BLANK()||[Last Employment Date]>=MIN('Calendar'[Period Start Date]))))

 

End HC 4:=CALCULATE(TeamMemberList[Employee ID],FILTER(TeamMemberList,[Last Hire Date]<=MAX([Last Employment Date])&&([Last Employment Date]=BLANK()||[Last Employment Date]>MAX('Calendar'[Period End Date]))))

 

Leaver 4:=CALCULATE(TeamMemberList[Employee ID],FILTER(TeamMemberList,TeamMemberList[Last Employment Date]>=MAX('Calendar'[Period Start Date])&&TeamMemberList[Last Employment Date]<=MAX('Calendar'[Period End Date])))

 

But all shown in errow. I have already linked the calendar table & TeamMemberList table in the diagram view.

  • v-danhe-msft's avatar
    v-danhe-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

    The calculation in PowerBI is same as PowerPivot in Excel.

    The measure could work on my side, could you please share your data file or pbix if possible?

     

    Regards,

    Daniel He

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Daniel,

       

      How can i send u the data file?