Forum Discussion
e2liu77
Helper I
Helper IHow refer the values from mapped tables
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!
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.
2 Replies
- lbendlin
Super User
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?
e2liu77C1 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.
