Forum Discussion
Solved
Finding Common Values Between Two Columns
Hi all, I have two columns. One with 500,000+ rows, the other with about 10,000. I am trying to use DAX to find the common values between these columns, is there any way to do this? Thanks! ...
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.
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.
parry2k
Super User
Super Userdonovan_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.