I have two tables of data, the first is EmployeeSalaryTbl which holds the salaries for employees over time:
and the second StaffDetailsTbl which has details on the employee discipline etc.
I'd like to repurpose a function I use to calculate total employee wages each month so that it only calculates salaries that are reliant on a specific discipline in a given cell, like programming.
To do this, I wondered if it was possible to filter the EmployeeSalaryTbl[Employee], EmployeeSalaryTbl[Salary Start Date], EmployeeSalaryTbl[Salary End Date], etc. results to only contain the rows where the employee has the Programming discipline through a lookup in the StaffDetailsTbl.