Forum Discussion

Mvumelwano's avatar
Mvumelwano
Icon for Helper I rankHelper I
6 years ago

lookup without common column

HI Team, Please assist with DAX, I have 2 tables (Table 1 and Table 2) and i need table 3 (see below example). always "a" = "I" and "d" = "m" and "e" = a measure (n+o) Table1 codes no a 1 ...
Need Help
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Mvumelwano 

create a Bridge Table by enter data manualy:

Code table1 Code table2
a I
d m
e e

 

create a relationshhips Table1 - bridge and table2 - bridge

and add what you need to visual