Visual filters on the same table

[timnilimaa]

Trying to do a filter between to visual tables that contains data from the same table.

So, my data table is like following

RowID;CustomerID;EmployeeID;StartDate;EndDate;AwesomeValue;

Now, in my report I have a table where the user selectes a row and a new table where I would like to show rows where StartDate is before the StartDate of the row the user selected.

Data example

1;22;331;08/07/2017 10:17AM;08/07/2017 02:14PM;42;

2;22;333;08/08/2017 09:19AM;08/08/2017 03:17PM;17;

3;99;128;08/07/2017 09:09AM;08/07/2917 09:19:PM;9;

If I in visual table A would select row 2 then row 1 would be visible in table B. Currently what I could get at the moment is that if I select row 2 in table A then that row is visible in table B. I'm leaning towards creating a new data table with the same data but I can't figure out how it would help really. In the long run, both StartDate and EndDate would be filtered to see what entries overlap with the selected entry.

[Phil_Seamark]

Hi there Sounds like you need two disconnected tables and a measure that you can use as a filter for the visual that is using Table B. The measure would return a 1 or 0 based on the comparison between the two start dates and can be used in the visual filter. Does that make sense? I can knock something up for you if you like. Phil

[timnilimaa]

If you could mock something that would be super helpful. Thanks for the reply btw.