Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Return another column based on condition

I am looking to return highest value  for city and corresponding vendor in my formula  City  Vendor  Price A         1           30 A         2           50 A         3          100 B         ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous 

     

    You may use the measure below.

    Measure =
MAXX ( TOPN ( 1, VendorRate, VendorRate[Price], DESC ), VendorRate[Vendor] )
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

Anonymous add a unique identifier like index column using power query and then use your measure to return index. once you have index, you can get whatever column you need for that row price/vendor etc.