Looking for specific text in cell based on another column
I'm trying to do a Find/Mid/Match in Power Query, but I'm not sure how to do it. Basically, I have a long list of article numbers and article names - inside these articles names it's stated which colour the product is. The issue is that it's not always in the same place. I have a query named "X_Colours" with one column "Colours" type is Text. Other query is "Items" with two columns "Item No" (Number) and "Name" (Text). I would like a custom column that looks in "Items" "Name" for a similar value from "X_Colours" "Colours" column. If it finds the same value, it should return the value from "X_Colours" if not, it should just return something like "Unknown", so I can manually look for the colour and add it to the list. Is this possible or do I have to create a new table and use an excel formula and then add it back into the query? Thanks in advance!
DAX to get Multiple Values for a record from another table
Dear All, I have a table called 'Record ID' which has distinct list of record ids and then i have a 'Details' table which has various details related to that record id. One record ID might have multiple values in another table. Example as below - Table 1 : Record ID Opportunity Name Account Name Opportunity Owner 0064G000013rD6mQAE Abhyudaya Co-Operative Bank-IT/PO-16/2017-18-40085308-10-$69 Abhyudaya Co-operative Bank Ltd Vinod Iyer 0064G000013snC6QAI Abhyudaya Bank - Nexus Switches and FW Case Abhyudaya Co-operative Bank Ltd Amey Khochare 0064G000013tHYtQAM Cisco-Accenture-GGN--Sheetal(DCCOR & others) Accenture Services India Pvt. Ltd. Seshasai Vaddadi 0064G000013rmYiQAI Adobe_Bangalore PTC Expansion Adobe Raghvendra Singh 0064G0000136tlJQAQ Remote office Airbus Mudit Shinghal 0064G0000136tlJQAQ Remote office Airbus Mudit Shinghal 0064G000013qkE3QAI Riverbed appliance Airbus Mudit Shinghal 0064G000012C2OJQA0 uDNS AMC Renewal Airtel Komal Grover 0064G000014qiEkQAI ASR 5G expansion Airtel Komal Grover 0064G000014rAlSQAU uDNS AMC-2 Airtel Komal Grover Table 2 Record ID Vertical Region-NEW BU SU Original Close Date 0064G000013rD6mQAE ENT West DI SS 4/26/2020 0064G000013snC6QAI ENT West DI Product 4/24/2020 0064G000013snC6QAI ENT West SEC Product 4/24/2020 0064G000013tHYtQAM ITES South-1 DI Training 4/30/2020 0064G000013rmYiQAI ITES North DI Product 4/27/2020 0064G0000136tlJQAQ Globals South-1 DI Product 4/16/2020 0064G0000136tlJQAQ Globals South-1 DI SS 4/16/2020 0064G000013qkE3QAI Globals South-1 DI Product 4/30/2020 0064G000012C2OJQA0 M&C North SEC SS 4/17/2020 0064G000014qiEkQAI M&C North DI Product 4/22/2020 0064G000014rAlSQAU M&C North SEC SS 4/22/2020 0064G000013rD6nQAE ENT West DW SS 4/30/2020 0064G000013qzr9QAA ENT South-1 DI Product 4/27/2020 Now i need to update Table 1 with values from Table 2. And i need to ensure that, were ever we have multiple values for one 'Record ID' they should appear as well. In the above example record id 0064G000013snC6QAI has 2 BUs in table 2 called DI & SEC so in table 1 i should have 2 rows one for DI and another one for SU and rest of the values can remain same. It should look like this : Record ID Opportunity Name Account Name Opportunity Owner Vertical Region-NEW BU SU Original Close Date 0064G000013snC6QAI Abhyudaya Bank - Nexus Switches and FW Case Abhyudaya Co-operative Bank Ltd Amey Khochare ENT West DI Product 4/24/2020 0064G000013snC6QAI Abhyudaya Bank - Nexus Switches and FW Case Abhyudaya Co-operative Bank Ltd Amey Khochare ENT West SEC Product 4/24/2020 I can't merge or append query as few coulmns in the table have been created using "LOOKUP" function. Regards, Krishna