Your data consists of employee salary details along with their tenure (years of service). I have cleaned and enhanced the data by adding the following calculated columns in Power Query:

1. Full Years of Service – Extracts the whole number of years an employee has worked by rounding down their tenure.
2. Bonus Percentage – Calculates the bonus percentage based on 1% per full year of service.
3. Bonus Amount – Computes the actual bonus an employee will receive by applying the bonus percentage to their salary.