How refer the values from mapped tables

[e2liu77]

Hi,

I have 3 tables:

Name

A

B

C

Priority

High

Medium

Low

Name	Priority	Gap
A	High	1
B	Medium	2
C	Low	3
A	High	4
B	Medium	5
C	Low	6

The first 2 tables are 1-multiple mappning to the thrid one.

Now I need to create a forth table:

Name	Priority	Origial	Target
A	High	X	X+ C1
C	Low	Y	Y+C6

C1 and C6 are the values from the third table location. How to refer the DAX fomular in "Target" column?

Thanks!

[e2liu77 · Accepted solution]

C1 and C6 are the location. Value is 1 and 6. Now I figured it out that vlookup will work for this with multiple search options.

[lbendlin]

If you want to address rows in DAX tables by row number then you need to provide that row number.   Your "gap"  column looks like a suitable candidate but that is likely only a coincidence?