Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Dear altruists,
I have a column with many values which can be increased, such as;
Column 1
Apple
Pear
Kaki
Avocado
etc...
These values I want to find in another column, for multiple values add a sign , such as "/". Ther power query I am looking for is Result column
Column 2--------Column Result
Apple is red--------Apple
Orange, Apple is orange--------Orange/Apple
Avocado, kaki goes bad--------Avocado/kaki
Kaki is yellow--------Kaki
Can any one help pls?
regards
Solved! Go to Solution.
I have taken your sample set and produced the below output
I created TBL1 which has Columns 1 and TBL2 which has the Column 2 containing text within which Column 1 is to searched.
The Custom column was created using the below Transformation step
If the solution matches your requirement, please let me know I will upload the PBIX file
Hi Manjo, it worked , thanks a lot. Have a good day.
I have taken your sample set and produced the below output
I created TBL1 which has Columns 1 and TBL2 which has the Column 2 containing text within which Column 1 is to searched.
The Custom column was created using the below Transformation step
If the solution matches your requirement, please let me know I will upload the PBIX file
Hi Manoj,
Sorry, its not working, i add here the formula. Can u pls have a look?
= Table.AddColumn(#"Changed Type", "Custom", each List.Accumulate(Table.ToList(#"Tbl1","",(state,current)=>if Text.Contains([Column 2], current)
then current&"/"&state
else state
)))
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
17 | |
9 | |
8 | |
7 | |
7 |