Forum Discussion

LucasRB90's avatar
LucasRB90
Frequent Visitor
6 years ago

Lookupvalue with multiple results

Hi Everyone, I have the following table ID / Target / Parent ID / Target from Parent ID x / x / x / lookupvalue formula The formula I used is Target from Parent = LOOKUPVALUE(DATA [Target],DATA [I...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

What is the error that you are getting? Are you getting back multiple results from your LOOKUPVALUE? You can try:

 

MAXX(FILTER('DATA',[ID] = [Parent ID]),[Target])

LucasRB90's avatar
LucasRB90
Frequent Visitor
6 years ago

Hi,

Thanks for that but it didn't solve my problem.

 

I need like a VLookUp for the column "Target Feature ID 2" based on the value of column "Work Item ID" and return the value of "Targeted Release Form"

So based on that I did 

LOOKUPVALUE(COMBINED[Targeted Release Form],COMBINED[Work Item Id],COMBINED[Feature ID 2])
 
But got the error of "A table with multiple values was supplied where a single value was expected"
 
If you can solve this I will be in debt lol

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    OK, now I am super confused becaues it looks like your Feature ID 2 always matches your Work ID in the same row so I am not sure what you are trying to do. 

     

    Please do the following:

    1. Post sample data as text using the table function in the editing bar. Just include the columns that are actually pertinent
    2. Post what you expect as output

     

    An explanation of the logic to get from a to b never hurts either. LucasRB90 

    • LucasRB90's avatar
      LucasRB90
      Frequent Visitor
      6 years ago

      Hi Greg,

       

      It reaches a point where the data is different from one column to the other.

      work item idtargeted release formfeature id 2target feature id 2
      10976820.4106850formula wanted
      10976820.4108431formula wanted
      11042520.4108431formula wanted

       

      So with this example, the formula that I want is like a VLookUp of excel that searchs for the value in "feature id 2" between column "work item ID" and returns the value from column "targeted release form"

      This table has arround 100k rows.

      The values in column "Feature ID 2" will be the parent ID of the ones in "Work Item ID" if that helps to understand the idea

       

      Thanks again