Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

LOOKUPVALUE missing identical lookups

Hello can someone help me. Why are more than half of the values missing from this simple vlookup. If one works they should all work. I even use trim function in wbs_blank_fix. My lookup table for this code only has 1 row 

COSTCENTER_fix = LOOKUPVALUE('sapdata SAP_projektelement'[Ansvarigt_kostnstl], 'sapdata SAP_projektelement'[WBS_element], 'sapdata SAP_costcalculationplan'[wbs_blank_fix])

 

 

 


  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    Anonymous LOOKUPVALUE will "fail" if there are multiple matches. Try using MAXX( FILTER( ... ), ... ) instead.

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous LOOKUPVALUE will "fail" if there are multiple matches. Try using MAXX( FILTER( ... ), ... ) instead.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Okay will try tomorrow, but I will add this project code is unique in the lookup table and I already used this lookup successfully in another table in the same model. So it is very wierd to me.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Update MAXX indeed did the trick and fixed my issues, thanks for the help