Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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.

3 ACCEPTED SOLUTIONS
Zubair_Muhammad
Community Champion
Community Champion

@Anonymous

 

Try this Column in Table with UserIDs

 

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

Regards
Zubair

Please try my custom visuals

View solution in original post

Anonymous
Not applicable

@Zubair_Muhammad It works. Thank you so much 🙂

View solution in original post

Hi @Anonymous

 

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

 

=
CALCULATE (
    MAX ( Table2[Date] ))

Regards
Zubair

Please try my custom visuals

View solution in original post

3 REPLIES 3
Zubair_Muhammad
Community Champion
Community Champion

@Anonymous

 

Try this Column in Table with UserIDs

 

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

Regards
Zubair

Please try my custom visuals
Anonymous
Not applicable

@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] ))

Regards
Zubair

Please try my custom visuals

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.