Forum Discussion
FrankJust
1 year agoRegular Visitor
Append two tables with overlapping date ranges
Hi, I'm trying to create a report that will calculate the FTE of a group of staff at a particular date, as well as showing the FTE minus absences. My problem is that I have two tables. One is...
- 1 year ago
Here is a pbix file with one method you could use. It will likely need to be amended once additional employees are introduced but the general idea should work.