Forum Discussion
Finding Common Values Between Two Columns
donovan_smith44 go to modelling table and click New Table and following expression
New Table = INTERSECT ( VALUES ( Table[First External Reference Number] ), VALUES ( Table[Second Externa Reference Number] ) )Above expression will add another table in your mode called New Table and that will have your data.
donovan_smith44 so let's put sample data here, which is always good way to explain and get the answer
Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Assuming your data looks like this
Col1 Col2
1 5
2 6
1
2
So in above case 1 and 2 from col1 exists in col2 and you want to show those values, correct?
Hi,
Thanks for reply and sharing-- should have looked into that guide more before posting.
Yes, you are correct.
I would like search First External Reference Number column for all of the values in the Second External Reference Number column, and then return a column with all of those values.
donovan_smith44 go to modelling table and click New Table and following expression
New Table = INTERSECT ( VALUES ( Table[First External Reference Number] ), VALUES ( Table[Second Externa Reference Number] ) )Above expression will add another table in your mode called New Table and that will have your data.
Thank you... this is exactly what I needed.