Forum Discussion

Suraj_46's avatar
Suraj_46
New Member
2 years ago
Solved

Date filter

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.

Custom Visuals
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.