Lookup table with matching value

Anonymous - Probably. See attached PBIX below sig, Tables (29), (29a), (29b), (29c). 29c is the output.

Table (29c) = 
    ADDCOLUMNS(
        GENERATE('Table (29)','Table (29a)'),
        "Owner",LOOKUPVALUE('Table (29b)'[Ower],[VM Name.1],[VM Name],"NA"),
        "Email",LOOKUPVALUE('Table (29b)'[Email],[VM Name.1],[VM Name],"NA"),
        "Subscription ID",LOOKUPVALUE('Table (29b)'[Subscription ID],[VM Name.1],[VM Name],"NA"),
        "Status",IF(COUNTROWS(FILTER('Table (29b)',[VM Name.1]=[VM Name]&&[Software Installed]=[Software Names]))>0,"Installed","Missing")
    )

 Turned out to be a lot of LOOKUPVALUE after all.

Greg_Deckler Thanks .It worked 🙂 

Can we also do this in same table (29B) instead of a new table creation . 

Anonymous - I do not believe so. If you want a full inventory you have to kind of "blowout" the table into more rows than you have in any of the base tables.