HR Dashboard

[tebtim19]

I'm just new in Power BI, might someone have idea how can I start to get the ff:

Number of New Hired employees

Total Active Employees

Total Inactive Employees

Hired Employees

Terminated Employees

%terminated

%hired

This was my sample table:

Thanks in advnace fo those who can give me idea thanks. 

[amitchandak · Accepted solution]

@tebtim19 , I checked the last post.

https://community.powerbi.com/t5/Desktop/HR-Management-Dashboard/m-p/1700499#M674872

You need to use employee ID in current employee. Also do not use .date, if there is no timestamp

You need to create a date table with month year. Please find the file attached after signatures