Find out how to do staff turnover calculation and gain insights on how many staff you have or how many staff have left over any period of time.
**** Video Details ****
0:25 - introducing staff turnover
1:06 - data model consideration/inactive relationships
2:10 - DAX formula for current staff at any time
2:45 - staff turnover calculation using CALCULATE function
4:02 - staff turnover formula results
5:10 - visualization review for staff turnover numbers
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-...
Learn more about Enterprise DNA - www.enterprisedna.co/
Enterprise DNA Membership - enterprisedna.co/membership
**** Related Links****
Total Number Of Staff Over Time - • Total Number Of Staff ...
How To Manage Multiple Date Calculations In Your Fact Tables - Advanced Power BI - • How To Manage Multiple...
How To Work With Multiple Dates In Power BI - blog.enterprisedna.co/2019/02...
**** Related Courses****
Solving Analytical Scenarios w/Power & DAX - portal.enterprisedna.co/p/solv...
Business Analytics Series - portal.enterprisedna.co/p/busi...
Unique Analytical Scenarios - portal.enterprisedna.co/p/uniq...
**** Related Support Forum Posts****
Staff Population - forum.enterprisedna.co/t/staf...
How to calculate Headcount over time - forum.enterprisedna.co/t/how-...
Salary Forecast - forum.enterprisedna.co/t/sala...
People analytics: headcount - forum.enterprisedna.co/t/peop...
Employee count by date - forum.enterprisedna.co/t/empl...
For more related posts see here - forum.enterprisedna.co/search...
11 июл 2024