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