Lookup measure from another table

[Anonymous]

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.

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try this Column in Table with UserIDs

=
CALCULATE (
    MAX ( Table2[Date] ),
    FILTER ( Table2, Table2[user id] = Table1[user id] )
)

[Anonymous · Accepted solution]

@Zubair_Muhammad It works. Thank you so much 🙂

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try this Column in Table with UserIDs

=
CALCULATE (
    MAX ( Table2[Date] ),
    FILTER ( Table2, Table2[user id] = Table1[user id] )
)

[Anonymous · Accepted solution]

@Zubair_Muhammad It works. Thank you so much 🙂

[Zubair_Muhammad · Accepted solution]

Hi @Anonymous

If the two tables have a relationship,, you can simply use

=
CALCULATE (
    MAX ( Table2[Date] ))