I have many queries attached to an SQL Power Query. I would love some help with the following for a Job Position Dashboard.
Some staff have duplicated job positions, either because they are in leadership positions or because they are teachers on leave. I would like to deduct the fte of staff on leave so I can have an accurate total FTE at any point in time. However, I'm not sure how to extract only those staff on leave (Parental/ LSL (Long Service Leave)/ Long term Carers Leave) as opposed to those who also have duplicate records due to their leadership or double roles e.g. some teachers are also Education Support officers.
I am thinking of a if then else statement but don't know how to do this with rows. I have attached an example of the file and the output which gives zero FTE. I would like this to show their FTE e.g. Joanna Bonner should show 1 as that is her usual FTE when not on LSL.
Thank you for any assistance.
Bookmarks