Problem to get third column value using two other columns

[Nukkumatti]

Hello,

I have following issue. I have two tables with following information

Table 1
PanelID	ReaderID	Name
1	1	Reader 1
1	2	Reader 2
1	3	Reader 3
1	4	Reader 4
2	1	Reader 5
2	2	Reader 6
2	3	Reader 7
Table 2
PanelD	ReaderID	Events	Name?
1	1	x
2	1	y
2	1	z
1	2	d
1	3	d

Now I wan't to add the Name column to the Table 2. The Panel ID is unique and the Reader name is based on the Panel ID and to the ReaderID. How can I do this?

[Vvelarde · Accepted solution]

hello @Nukkumatti

Create a calculated column with this dax:

Name = LOOKUPVALUE(Table1[Name],Table1[PanelID],Table2[PanelD],Table1[ReaderID],Table2[ReaderID])

[Nukkumatti]

Thank you Vvelarde. Worked perfectly! 🙂