Forum Discussion
Lookup measure from another table
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.
Anonymous
Try this Column in Table with UserIDs
= CALCULATE ( MAX ( Table2[Date] ), FILTER ( Table2, Table2[user id] = Table1[user id] ) )Zubair_Muhammad It works. Thank you so much :)
Hi Anonymous
If the two tables have a relationship,, you can simply use
= CALCULATE ( MAX ( Table2[Date] ))
3 Replies
Anonymous
Try this Column in Table with UserIDs
= CALCULATE ( MAX ( Table2[Date] ), FILTER ( Table2, Table2[user id] = Table1[user id] ) )Zubair_Muhammad It works. Thank you so much :)
Hi Anonymous
If the two tables have a relationship,, you can simply use
= CALCULATE ( MAX ( Table2[Date] ))