Hi,
I'd like to do a 2 dimensional lookup between 2 tables in my Power Pivot data model:
Table 1 (source/raw data):
<tbody>
</tbody>
Table 2 (lookup):
<tbody>
</tbody>
Question....how do I get the values in Table 2's 'Lookup Result' column? ie - what is the DAX syntax to do this as a calculated column in table 2 without transforming/rearranging the raw data in table 1? Normally i'd use 2 nested MATCHs within an INDEX in Excel.....
Thanks in advance guys!
I'd like to do a 2 dimensional lookup between 2 tables in my Power Pivot data model:
Table 1 (source/raw data):
Category | Type1 | Type2 |
A | 1 | 2 |
B | 3 | 4 |
C | 5 | 6 |
<tbody>
</tbody>
Table 2 (lookup):
Category | Type | Lookup Result? |
A | Type2 | 2 |
C | Type1 | 5 |
<tbody>
</tbody>
Question....how do I get the values in Table 2's 'Lookup Result' column? ie - what is the DAX syntax to do this as a calculated column in table 2 without transforming/rearranging the raw data in table 1? Normally i'd use 2 nested MATCHs within an INDEX in Excel.....
Thanks in advance guys!