Display between selected 2 dates

Hi,

I have a  dates table with all calendar values, and another table project with the occupancy of the person . I wanted to display the people availability of the person from a particular start date to end date.

My approach is creating two slicer one for start date,one for end date and then a matrix to display the name and availability.

Example,

if A is allocated to project from 1-march 2024 to 15-june 2024

Then if selected date is 1-feb to 30 march then availability for feb should be 100% and march should be 0%

If selected date is 15may to 30june then may should be 100%, june 50%