How can i add new columns from other table?

[Marcus_S]

Hello,

I have a table A which needs to be extended by two columns.
The additional information is in Table B, but in different rows.
How would I have to create these columns?

Table A

NO	Decsription	ADD 1	ADD 2
123456	Test	Value from Table B Typ A	Value from Table B Typ B

Table B

No	Typ	Value
123456	A	000
123456	B	111

Thanks a lot

Marcus

[Marcus_S]

@amitchandak i used the dax solutions, and it works fine.

Thanks a lot

Marcus

[amitchandak · Accepted solution]

@Marcus_S , In dax

MAxx(filter(Table2, Table1[No] = Table2[NO] && Table2[Type] ="A") , Table2[Value])

column 2

MAxx(filter(Table2, Table1[No] = Table2[NO] && Table2[Type] ="B") , Table2[Value])

In power query merge and Pivot

Merge Tables (Power Query) : https://www.youtube.com/watch?v=zNrmbagO0Oo&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=16

Pivot Data(Power Query) :https://www.youtube.com/watch?v=oKByyI09Bno&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=12