lookupvalue but with multiple results

[alisaigar]

Hi all

I need some help on PowerBI

Im trying to lookup a value from another table, except that other table has multiple rows with the same value that im looking up.

This ofcourse results in an error.

Each row has a 'createdon' date, so I thought it would be best to lookup the row with the earliest 'createdon' date.

So in short, i need a lookupvalue [or a summarize formula] which will lookup the 'customerid_account.name' column within the 'opportunity' table, and return the most recent 'statuscode' (also from within the opportunity table)

I hope this is clear. Ive tried various options but I cant seem to get it.

Thanks in advance
Ali

[TeigeGao]

Hi @alisaigar ,

Actually, in your scenario, we can use the TOPN() function to get the the most recent 'statuscode' for each customerid_account.name, for more information, please refer to this document: https://docs.microsoft.com/en-us/dax/topn-function-dax

Best Regards,

Teige