Forum Discussion
Create new query table from existing table with criteria (Employee Leave Records)
Hi all, Problem Statement: I need a clean table of employee leave application with the following adjustments: Leave Start/End date Adjusted by the Quarter (parameter can be manually set in Power ...
Sounds like something you might be able to do using Merge Queries.
Thanks Ehren, you're right, a Left/Right Anti join type will solve this challenge after ensuring both table structures are the same.
Problem 2: Adjusting the Leave Start and End date to the year, quarter, and month; factoring in Public Holidays (and rosters, but I can use the solution for public holiday for this)