Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
@Anonymous , Try a new column like
if( Table1[value] = maxx(filter(Table2, Table2[Serialnumber] = table1[Serialnumber]),Table2[Value]),1,0)
I tryed this:
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.😅
@Anonymous Maybe:
Column = LOOKUPVALUE('TableB'[Value],'TableB'[Serialnumber],'TableA'[SerialNumber])
Din't work. The error message is: A table with several values was returned although a single value was expected.
User | Count |
---|---|
66 | |
46 | |
20 | |
19 | |
15 |
User | Count |
---|---|
121 | |
41 | |
38 | |
28 | |
23 |