Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!!
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.
@fiorela I guess in your relationship Table2 is on one side of the relationship, correct?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
yes, correct !
User | Count |
---|---|
120 | |
95 | |
88 | |
73 | |
66 |
User | Count |
---|---|
138 | |
112 | |
110 | |
98 | |
94 |