Look up value with lowest rank

[Sivarg]

Hi all,

I am trying to look up in Power BI, Sample file here

I need to lookup the column "location" from the 'Lookup Table' to 'My Table'

The Video ID is used to link between two tables. However the video ID has duplicates in it.

Question- How can I create a new column 'Location' in My Table and lookup the location values from Lookup Table that has the lowest Sequence number.

Also keen to know how to do the opposite(location that has highest sequence number)

Can you please help.

Thanks in advance.

 

[Sivarg]

I was able to resolve this with assistance. Thanks