Forum Discussion
Lookup Value from another Table
pls try if lookupvalue works for you
LOOKUPVALUE function (DAX) - DAX | Microsoft Docs
LOOKUPVALUE(
TableB[URL],
TableB [vunlerable manufacuturer Found].
TableA [vunlerable manufacuturer Found].
TableB [Vulnerable Souftware Found].
Table A[[Vulnerable Souftware Found])
Not sure if this was your suggestion , here is what i have tried which did not return any value.
URL =
LOOKUPVALUE(vuldb_id_report_no_version[URL],
vuldb_id_report_no_version[Manufacturer],bov_software[Vulnerable Manufacturer Found],vuldb_id_report_no_version[Software],bov_software[Vulnerable Software found]
)
Table A Sample
| Software | Manufacturer | Vulnerable Manufacturer Found | Vulnerable Software Found | URL |
| Microsoft Silverlight | Microsoft Corporation | |||
| Realtek High Definition Audio Driver | Realtek Semiconductor Corp. | |||
| Update for Windows 10 for x64-based Systems (KB4023057) | Microsoft Corporation | |||
| Microsoft Update Health Tools | Microsoft Corporation | |||
| Grammarly for Windows | Others | |||
| Microsoft Azure Information Protection | Microsoft Corporation | |||
| Microsoft Visual C++ 2008 Redistributable - x86 9.0.30729.4974 | Microsoft Corporation | |||
| Microsoft SQL Server 2008 R2 Management Objects | Microsoft Corporation | |||
| Enterprise Communicator | CA | |||
| GNOME CORBA ORB and component framework | Oracle Corporation | |||
| Xmanager 6 | NetSarang Computer, Inc. | |||
| JDK 8.0 64-bit Runtime Env. (1.8.0_311) | Oracle America, Inc | |||
| Microsoft Edge | Microsoft Corporation | |||
| Nessus Agent (x64) | Tenable, Inc. | |||
| Oracle - OraClient19Home1 | Others | |||
| Oracle - OraClient11g 11.2.0 | Others |
Table B sample
| Entry ID | Manufacturer | Software | Version | Type | Platform | Date |
| https://vuldb.com/?id.207464 | TOTOLINK | empty | 4.1.2cu.5185_B20201128 | empty | empty | 08-29-09:20 |
| https://vuldb.com/?id.207463 | TOTOLINK | empty | 4.1.2cu.5182_B20201027 | empty | empty | 08-29-09:20 |
| https://vuldb.com/?id.207462 | TOTOLINK | empty | 4.3.0cu.7647_B20210106 | empty | empty | 08-29-09:20 |
| https://vuldb.com/?id.207461 | TOTOLINK | empty | 4.1.2cu.5204_B20210112 | empty | empty | 08-29-09:20 |
| https://vuldb.com/?id.207460 | TOTOLINK | empty | 4.1.2cu.5137_B20200730 | empty | empty | 08-29-09:21 |
| https://vuldb.com/?id.207459 | TOTOLINK | empty | 4.1.5cu.532_B20210610 | empty | empty | 08-29-09:21 |
let's clarify the logic
This is the first row of table A
Software Manufacturer Vulnerable Manufacturer Found Vulnerable Software Found URL Microsoft Silverlight Microsoft Corporation How do you want to get the value for the last 3 columns from Table B?
in my opinion, based on the sample data you provided, we can't get the expected output below.
Software Manufacturer Vulnerable Manufacturer Found Vulnerable Software Found URL Microsoft Silverlight Microsoft Corporation Microsoft Silverlight Microsoft Corporation https://vuldb.com/?id.207623 Table A contains calculated values for Vulnerable software found and Vulnerable Manufacturer Found based on the following formula :
MAXX ( FILTER ( vuldb_id_report_no_version, SEARCH ( vuldb_id_report_no_version[Software], bov_software[Software], 1, 0 ) > 0 ), [Software] )Therefore they are calculated values which are filtered from Table B and A.
What I want to achieve is if they are populated and not blank , get the Entry ID from table B and insert it in Table A .Hope this makes it more clear now.
Tried the bellow formula with no success.
URL = IF(NOT(ISBLANK(bov_software[Vulnerable Manufacturer Found] || bov_software[Vulnerable Software found])), FILTER(vuldb_id_report_no_version,SEARCH(vuldb_id_report_no_version[URL],vuldb_id_report_no_version[URL])) )i tried your DAX and it returns null.
maybe you can try the pbix file attached or you can provide your pbix file based on the sample data.