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...
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.

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.