Forum Discussion

nicolasvc's avatar
nicolasvc
Helper III
4 years ago
Solved

Get data from another column and function earlier

I have a table like the following one in which I use the earlier function to calculate the sum of each product, but now I have another table in which I have a percentage, and this value I need to mul...
Need Help
Show and Tell
Tips and Tricks
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, nicolasvc

    You can try the following methods:

    1. I have prepared tables a and B first. Sum is the calculation column.

    2. Use the LOOKUPVALUE function to match the sum column of table A to table B.

    Sum =
LOOKUPVALUE ( A[Sum], A[ Store], [Store], A[ Product], [ Product] )

    3. The value you want is shown in the figure:

    Value = B[Sum]*B[ Percentage]

    If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

    Best Regards,

    Charlotte Zhang

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

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, nicolasvc

You can try the following methods:

1. I have prepared tables a and B first. Sum is the calculation column.

2. Use the LOOKUPVALUE function to match the sum column of table A to table B.

Sum =
LOOKUPVALUE ( A[Sum], A[ Store], [Store], A[ Product], [ Product] )

3. The value you want is shown in the figure:

Value = B[Sum]*B[ Percentage]

If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

Best Regards,

Charlotte Zhang

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