Forum Discussion

brethomp's avatar
brethomp
Frequent Visitor
7 years ago

Employee Turnover with Date Hierarchy

I have employee data organized by week, similar to below. So for each week that an employee has been with the company, they will have a line item in the data for that week with thier status in that w...
Need Help
ChandeepChhabra's avatar
ChandeepChhabra
Icon for Impactful Individual rankImpactful Individual
7 years ago

brethomp 

  1. I am not sure if a stacked visual is possible if you are trying to show a total of 5 emp and then split by terminated and hired employees
  2. To get the total employees by month, you can revise the active employee measure = DISTINCTCOUNT(Emp[Emp ID])

 

If I din't answer your question adequately, could you please share your data and snapshot of the output that you are expecting

 

Thanks

brethomp's avatar
brethomp
Frequent Visitor
7 years ago

ChandeepChhabra, thank you for trying to help, but I am not ready to give up yet. DAX seems like a powerful tool, there could be a way to accomplish this. Maybe somone else has an idea. I know it is a piece of cake in SQL, but doing it there I would need to bring in 4 different views of the data into Power BI for Year, Quarter, Month, and Week, and not use the drill down tools in Power BI.