Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi PBI Community,
Is there a way to do a conditional lookup? I have a table with user ids and I need to get the last date the user was active from another table that has user id and dates. Is it possible to do that?
Your reponses are greatly appreciated.
Solved! Go to Solution.
@Anonymous
Try this Column in Table with UserIDs
= CALCULATE ( MAX ( Table2[Date] ), FILTER ( Table2, Table2[user id] = Table1[user id] ) )
Hi @Anonymous
If the two tables have a relationship,, you can simply use
= CALCULATE ( MAX ( Table2[Date] ))
@Anonymous
Try this Column in Table with UserIDs
= CALCULATE ( MAX ( Table2[Date] ), FILTER ( Table2, Table2[user id] = Table1[user id] ) )
Hi @Anonymous
If the two tables have a relationship,, you can simply use
= CALCULATE ( MAX ( Table2[Date] ))
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |