Date filter

[Suraj_46]

Hi,

Im having timesheet data of employees by column name like Name, start_date and end_date.

Consider startdate as join date and end date as resign date.

I want employee who have start date and end date to be show in that particular month only & employee who only have start date to be shown in next month as well.

For Example = if employee A who joined (startdate) is june 1st 2023 and enddate is 30th june 2023 then that employee should be only be shown in june month.

Howver, if employee B is joined on 1st june and has no end date(resigned), then if im applying date slicer filter on july then that employee B should be shown in july month table as well.

[Anonymous · Accepted solution]

Hi @Suraj_46 ,

I made simple samples and you can check the results below:

Measure = var _select = MIN('Table 2'[Date])
VAR _END = MAX('Table'[End])
RETURN IF(_END<>BLANK()&&_END<_select,1,0)

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.