How to replicated an IF formulan in PowerQuery

Hi All,

I have a IF formula in excel which is working fine for accumulating a sickness day calculation for employees. But some reasons I will move the file to power query and therefore I need to replicate the formulas in Powerquery. But my power query knowledge is limited for that. In this point, may I kindly ask your help on how to achieve same result in power query ?

So, here is my attached file. I have a table with employees sickness start dates which is "Date" column. Based on company rule, if the sickness is taken more than 3days in 7 days time period, first 3 days is % 50paid and rest is unpaid.
That's our holy rule In "P" column I am checking the 7day rules and In "Q" column, i am indexing the continuous dates. if its not continuous/in 7 days; i am starting from 1. At the end, I will mark everything <=3 as paid, rest unpaid which is the easy part.

Any idea how to do this indexing (column Q) in Power Query ?

PS: "employee logon" column is for keeping the calculation for that spesific employee. Thats why, there is always if E3=E2 formula.

Let me know if you need anything. Any tips or start point for me in power query would be also much appreciated.

Thanks a million
Orhan

Capture.JPG