Forum Discussion
date filter - joined tables
Hi guys,
I have two tables joined by URL:
Table1
| date | url | User | Category |
| 3/26/2020 18:30 | ht//hello | juan | A |
| 2/2/2020 17:15 | ht//goodbye | peter | B |
3000 rows like this with different users.
Table2
| date | url |
| 3/23/2020 18:30 | ht//goodbye |
| 3/10/2020 17:15 | ht//hello |
and I would like filter a table (or matrix) by Date of Table2 (is on or after 3/23/2020). i.e, I would like to see all users (table1) that have a particular URL after 3/23/2020 (table2).
I've put the field in filter pane, but it doesn't work. It appears that "is on or after" doesnt filter the date as I want. It only show one rows.
Any suggestions?
Thanks in advance!!
4 Replies
Hi fiorela ,
We can create a measur as below and make the table visual filtered by it.
Measure = VAR seled = SELECTEDVALUE ( 'Table (2)'[date] ) VAR ur = MAX ( 'Table (2)'[url] ) RETURN IF ( MAX ( 'Table 1'[date] ) >= seled && MAX ( 'Table 1'[url] ) = ur, 1, BLANK () )Pbix as attached.
sadly it didn't work. In your example, the date 3/26/2020 should even appear and it does not. Thanks anyway for your time.
yes, correct !
