Problem to get third column value using two other columns

Question

Hello,&nbsp;I have following issue. I have two tables with following informationTable 1&nbsp;&nbsp;&nbsp;PanelIDReaderIDName&nbsp;11Reader 1&nbsp;12Reader 2&nbsp;13Reader 3&nbsp;14Reader 4&nbsp;21Reader 5&nbsp;22Reader 6&nbsp;23Reader 7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Table 2&nbsp;&nbsp;&nbsp;PanelDReaderIDEventsName?11x&nbsp;21y&nbsp;21z&nbsp;12d&nbsp;13d&nbsp;&nbsp;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 Answer

hello&nbsp;Nukkumatti&nbsp;Create a calculated column with this dax:&nbsp;Name = LOOKUPVALUE(Table1[Name],Table1[PanelID],Table2[PanelD],Table1[ReaderID],Table2[ReaderID])

Forum Discussion

Problem to get third column value using two other columns

2 Replies

Related content

New Column

Grouping rows by Column and then updating Column

Transform columns / type

Unpivot Column

Adding columns

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