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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Help with a lookup/max, etc expression

 

 

Could anyone help me with a Power BI Formula please?

 

Hopefully the diagram attached shows it pretty clearly, but I need to write a formula in the "Unique Works Order Numbers" table that basically does a lookup of the works order number on the "Final and Supp" table, picks the latest "Date Sent" for that number, then returns the "created by" name. Many Thanks

 

PB Problem.JPG

1 ACCEPTED SOLUTION
Zubair_Muhammad
Community Champion
Community Champion

@Anonymous 

 

Give this a shot

I assume Tables are related by WO_Number

 

Column =
MAXX (
    TOPN ( 1, RELATEDTABLE ( 'Final and Supp' ), 'Final and Supp'[Date sent], DESC ),
    [Created By]
)

View solution in original post

2 REPLIES 2
Zubair_Muhammad
Community Champion
Community Champion

@Anonymous 

 

Give this a shot

I assume Tables are related by WO_Number

 

Column =
MAXX (
    TOPN ( 1, RELATEDTABLE ( 'Final and Supp' ), 'Final and Supp'[Date sent], DESC ),
    [Created By]
)
Anonymous
Not applicable

This works, great, fantastic.  Thank you for your help

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.