Help with a lookup/max, etc expression

[Anonymous]

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

[Zubair_Muhammad · Accepted solution]

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

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