Filter Jobs in between the start date and end date

[Afiq_Danial]

Hi,

I have an issue with my calculation which I am not sure what went wrong.

Firstly, I have this set of data,

I have a filter table by Month, and Year.

When I selected the June, 2021 filter, it would provide only Job A as it should be because Job A was taking place in that period. It should display like this.

However, I realised when I took away the Start Date column from the table, it would be showing both Job A and Job B.

My calculation to get the ongoing job between the start and end date is:

M Filter Recovery Date =

IF (

SELECTEDVALUE('Staff Booking'[Start Date]) <= MAX ( 'Job Calendar'[Job Duration] )

&& SELECTEDVALUE ( 'Staff Booking'[End Date] ) >= MIN ( 'Job Calendar'[Job Duration]),

1

)

Can anyone tell me where i went wrong in my calculation? 

Thank you very much, really appreciate all the help i can get.

[HoangHugo]

Hi

Maybe when you remove Start Date, SELECLTEDVALUE([('Staff Booking'[Start Date]) =BLANK, ~ 1/1/1990, so the condition of start date of Job B will be true. Otherwise, if have Stardate, Stardate of Job B >=MAX ( 'Job Calendar'[Job Duration] , so it's false.