I’m a newbie in Excel Power queries (M) and would appreciate some assistance. I have a table with the structure below. I would like to populate a column called “Daily Wage”, which is = “3 month Salary” divided by 90 (days in 3 months). The difficulty is that:

1. on Fridays, given the weekend, the ‘Daily Wage’ will cover 3 days, so it will be 3x the other work days

2. Secondly, the “3M Salary” is missing in certain rows. In that case, we can proxy it with the person’s previous 3 month salary (look for prior rows for that person until the 3m salary is found)

Example Table:

Thank you!

Struggled when the 3 Month Salary is missing