Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have several queries that are located on a server.
One query has a complete set of data such as:
TABLE 1
Code1 | Code2 |
12345678 | whatevercode1 |
12345679 | whatevercode2 |
12345680 | whatevercode3 |
I would like the return the corresponding Code2 based on the existing Code1 in another table from another query.
In Excel I would use something along an INDEX MATCH to get the code.
Note, Code1 MIGHT not be unique, duplicates may exists, but Code2 would always be the same for said Code 1
Excpected result:
New query table
TABLE 2
Qty | Code1 | ExtractedCode2 |
23 | 12345678 | whatevercode1 |
345 | 12345679 | whatevercode2 |
12 | 12345680 | whatevercode3 |
Solved! Go to Solution.
Hello @Cyrilbrd ,
Try this
Extracted Code 2 = LOOKUPVALUE('Table1'[Code2],'Table1'[Code1],'Table2'[Code1])
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍
Proud to be a Super User! | |
Hello @Cyrilbrd ,
Try this
Extracted Code 2 = LOOKUPVALUE('Table1'[Code2],'Table1'[Code1],'Table2'[Code1])
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍
Proud to be a Super User! | |
Thanks
I tried a variation of the following:
CALCULATE ( MAX ( PLM_DATA[PLM_PN] ), FILTER ( PLM_DATA, CONTAINSSTRING ( AP_DATA[aP_Model], PLM_DATA[PLM_Model] ) )
But the query would not load.
The proposed solution is fast to load and works.
Thanks.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |