Forum Discussion

PaulaL's avatar
PaulaL
Frequent Visitor
7 years ago
Solved

Lookup with an if condition

Hi, I am having issues with incorporating an If statement into my LOOKUPVALUE formula (if this is even the correct way to approach it)

 

I am using theInstalledSoftware table as my Main table where I would like to display the information... I need to lookup the information from the Merge1 table and but I only need to copy the information into InstalledSoftware if the ProductName column has the word %project% in it (I need project to be inside a wildcard or similar to a like function as there are mutliple different versions)

 

Table Names: Merge1 & InstalledSoftware 

 

LOOKUPVALUE COLUMN
Column = LOOKUPVALUE(Merge1[XLS_Project Online.Licence],Merge1[Netbios_Name0],InstalledSoftware[vSMS_R_System_NetBIOS])
 
Any help would be greatly appreciated
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    7 years ago

    PaulaL -

     

    If you have a relationship between the tables, this works in my small sample:

    Column =
IF (
    SEARCH (
        "product",
        RELATED ( Merge1[productName] ),
        1,
        0
    ),
    RELATED ( Merge1[productName] )
)



     

1 Reply

  • ChrisMendoza's avatar
    ChrisMendoza
    Icon for Resident Rockstar rankResident Rockstar
    7 years ago

    PaulaL -

     

    If you have a relationship between the tables, this works in my small sample:

    Column =
IF (
    SEARCH (
        "product",
        RELATED ( Merge1[productName] ),
        1,
        0
    ),
    RELATED ( Merge1[productName] )
)