Forum Discussion
Compare two diffrent tables
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 ...
amitchandak
Super User
Super UserAnonymous , Try a new column like
if( Table1[value] = maxx(filter(Table2, Table2[Serialnumber] = table1[Serialnumber]),Table2[Value]),1,0)
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.😅