employee turnover by company

[Anonymous]

Hey everyone,  I am hoping someone can help me

I am trying to find Employee turnover by Year/Company

I have and employee table  and I have created a Calendar table

The employee table has the following columns

ID

Hire Date

Term Date

Company

Active Status

I would like to createa dashboard to show by

Company turnover % by Year (2018 & 2019)-- Matrix Chart

Turnover by Month --- Line Chart (as a whole)

please help... 

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly?

If you still need help, please feel free to ask.

Best  Regards,

Cherry

[v-piga-msft]

Hi @Anonymous ,

More details will be much helpful.

If it is convenient, could you share some data sample which could reproduce your scenario and your desired output so that we could help further on it.

In addition, you could refer to this blog which will guide us how to calculate the turnover and the similar threads below.

https://community.powerbi.com/t5/Desktop/Calculate-HR-turnover-and-show-trend/td-p/27512

Best  Regards,

Cherry