Total Number Of Staff Over Time - Power BI Insights

In this example, we are attempting to work out how many staff we have at any one time.

The technique discussed here is relevant for when you have a table with multiple dates in it and you need to run logic through that table to work out if an employee is still a staff member at any period of time.

This is also the technique to use if you want to showcase staff numbers or growth through time.

We utilise the correct relationship technique and also the 'events in progress' pattern to get this all to work successfully in Power BI.

**** Video details ****
1:40 - staff population data and model
3:22 - choosing the context
3:56 - formula for current staff

**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...

**** Related Links ****
How To Work With Multiple Dates In Power BI - https://blog.enterprisedna.co/working...
Master Virtual Tables In Power BI Using DAX - https://blog.enterprisedna.co/working...
Counting Customers Over Time Using DISTINCTCOUNT In Power BI - https://blog.enterprisedna.co/countin...

**** Related Course Modules ****
Time Intelligence Calculations - https://portal.enterprisedna.co/p/tim...
Business Analytics Series - https://portal.enterprisedna.co/p/bus...
Mastering DAX Calculations - https://portal.enterprisedna.co/p/mas...

**** Related Support Forum Posts ****
Staff Population - https://forum.enterprisedna.co/t/staf...
Help With Adapting Current Staff Calculations - https://forum.enterprisedna.co/t/help...
Date Stamp Weekly Excel Import - https://forum.enterprisedna.co/t/date...
For more staff population support queries to review see here…. - https://forum.enterprisedna.co/search...