topic Re: Compare two diffrent tables in DAX Commands and Tips

Compare two diffrent tables

Anonymous — Mon, 14 Sep 2020 09:35:20 GMT

Hello Power Bi Community,

I need to create a new column in table A to compare two serial numbers from two different tables (one is in table A and the other in table B), if the serial number matches I need to insert in the new column in table A a value from table B which is in the same row as the serial number. For example:

Tabel A:

Serialnumber	New created column
1	12,3
2	11,4
3
4	13
5

Tabel B:

Serialnumber	Value form tabel B
1	12,3
2	11,4
4	13

Thanks for your help

Greeting Lukas

Re: Compare two diffrent tables

Greg_Deckler — Mon, 14 Sep 2020 09:42:29 GMT

Anonymous Maybe:
Column = LOOKUPVALUE('TableB'[Value],'TableB'[Serialnumber],'TableA'[SerialNumber])

Re: Compare two diffrent tables

Anonymous — Mon, 14 Sep 2020 09:54:41 GMT

Din't work. The error message is: A table with several values was returned although a single value was expected.

Re: Compare two diffrent tables

amitchandak — Mon, 14 Sep 2020 10:34:56 GMT

Anonymous , Try a new column like

if( Table1[value] = maxx(filter(Table2, Table2[Serialnumber] = table1[Serialnumber]),Table2[Value]),1,0)

Re: Compare two diffrent tables

Anonymous — Mon, 14 Sep 2020 11:35:45 GMT

I tryed this:

New column = if(LOOKUPVALUE(Table2[SN],Table2[SN],Table1[SN]),1,0)

With this function I have a 1 in every line where the serial numbers are the same. Now I just have to somehow replace the 1 with the value in table 2.😅