Forum Discussion

EZgrafton's avatar
EZgrafton
Icon for Advocate II rankAdvocate II
10 years ago

Calculate Employees Turnover

I need to calculate the employees turnover and allow the users to drill down our five level of hierarchy (so, basically down to department level).   First question, can I do that on Power BI or sho...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hey I'm working on the exact same thing. From the sample of data you provided, it looks like our database is setup very similar. 

 

In general, I'm creating measurements and/or columns for metrics where needed. I haven't spent enough time yet on turnover rate to have it completely figured out yet. Once I do I'll share or if you already have figured it out, can you let me know how you did it?

 

Side note, is there an advantage to running your data through Power Pivot first?

EZgrafton's avatar
EZgrafton
Icon for Advocate II rankAdvocate II
10 years ago

Sure will! 

 

On the Power Pivot first, I am not sure. I watched a lot of videos on modeling and many of them seem to go through Power Pivot, but I don't know if it is necessary or if you can achieve the same results going straight on Power BI. I am trying to find out the most efficient way of building models. Hopefully someone will clarify this for me/us.

 

Cheers!