Total Number Of Staff Over Time

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

The technique discussed here are 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.



***** Learning Power BI? *****

FREE COURSE - Ultimate Beginners Guide To Power BI -

FREE COURSE - Ultimate Beginners Guide To DAX -

FREE - Power BI Resources -

FREE - 60 Page DAX Reference Guide Download -

Learn more about Enterprise DNA -

Enterprise DNA Membership -

Enterprise DNA,Sam McKay,Power BI,DAX,PowerBI,DAX tutorial,Power BI tutorial,Power BI Desktop,Powerpivot,DAX Power BI,Power BI Time Intelligence,Power BI DAX,How to learn DAX,Learn Power BI,Power BI training,DAX training,Time Intelligence,Data analysis,Power BI for beginners,Analytics,Dashboards,DAX for beginners,Advanced DAX,Total of Averages DAX,Average Total Power BI,Total of Average Power BI,Average Totals DAX,AVERAGEX Power BI,