hmltnangel
Active Member
- Joined
- Aug 25, 2010
- Messages
- 290
- Office Version
- 365
- Platform
- Windows
Morning all,
My PBI skills are slowly improving but im stumped on this one.
The data table contains a list of all staff from the beginning of time. These staff have "Start Date" and "End Date" for their employment. Its easy to work out "Current Employees", and "Leavers" in last X months. But how do i work out the average staff that were employed between two dates?
Is it a simple Power Query formula, which then changes dynamically with a slicer? Or is there a better way to do things?
My PBI skills are slowly improving but im stumped on this one.
The data table contains a list of all staff from the beginning of time. These staff have "Start Date" and "End Date" for their employment. Its easy to work out "Current Employees", and "Leavers" in last X months. But how do i work out the average staff that were employed between two dates?
Is it a simple Power Query formula, which then changes dynamically with a slicer? Or is there a better way to do things?