Forum Discussion

Mueez's avatar
Mueez
Frequent Visitor
5 years ago
Solved

Help Needed with Lookup Function

Hi,   I have a very simple code in calculated cloumns where I am using lookup value to get required information from another table.   =LOOKUPVALUE('Knock off details for AP'[Document No.],'Knoc...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi Mueez ,

     

    I give an sample.

    I have two tables like this.

    --Table

    --Table(2)

    Then I create a calculated column in 'Table'.

    The cause of the error is this, Table(2) has two values that are not aggregated.

    You can do like this.

    1. Create a calculated column in 'Table(2)'

    2. LOOKUPVALUE()

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Fowmy's avatar
Fowmy
Super User
5 years ago

Mueez 

For the criteria you provided in the LOOKUPVALUE function, there could be more than one value returned from 

'Knock off details for AP'[Document No.]. Please check the table 'Knock off details for AP'

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn
  • Mueez's avatar
    Mueez
    Frequent Visitor
    5 years ago

    @Fowmy Thanks for replying

    I am pretty sure there are no duplicates because when I change code as following I stop getting error.

    = LOOKUPVALUE ('Cancellation details for AP' [Document No.], 'Knock off details for AP' [Vendor Ledger Entry No.], <hard code entry number>, 'Knock off details for AP' [ Entry Type], "Application" )

    But this is obvioulsy not what I want. The formula needs to iterate through each line in of the table.

    Best Regards,

    Mueez

    • Mueez's avatar
      Mueez
      Frequent Visitor
      5 years ago

      Fowmy 

       

      Also, even if say there are duplicates. Isn't there way we can handle those?

       

      Regards,

      Mueez

      • Fowmy's avatar
        Fowmy
        Super User
        5 years ago

        Mueez 

        A column cannot contain two Document Numbers. That is not the right way. But, you can still do it using CONCATNATEX and FILTER functions

        ________________________

        If my answer was helpful, please consider Accept it as the solution to help the other members find it

        Click on the Thumbs-Up icon if you like this reply 🙂

        YouTube  LinkedIn