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.

v-lionel-msft's avatar
v-lionel-msft
Community Support
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.

  • Mueez's avatar
    Mueez
    Frequent Visitor
    5 years ago

    Thank you so much! 

    Much Thanks!

     

    Regards,

    Mueez