Display between selected 2 dates

[Drake1002]

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%

[PhilipTreacy · Accepted solution]

@Drake1002 

Doesn't that solve the problem?

Phil

[Drake1002]

No it doesn't 

[PhilipTreacy]

Hi @Drake1002 

Can't you set the slicer style to 'Between' so that you can use a single slicer to set the earliest and latest dates?

Regards

Phil

[Drake1002]

Yes I can