Hi,
I am an expert in Power bi and ave completed 100+ power bi project, you can check the reviews by employers on my profile.
I have completed similar projects before.
In the HR dashboard, I have created the same formula which had termination date.
I can show any number of weeks of past or future as automated.
pleas send me the data, I can show you a quick demo.
waiting for your reply.
Thanks