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.
jthomson
Solution Sage
Solution SageCould make a new table that just takes a union of the distinct values of each, relate your original two tables to it, then make a measure multiplying countrows of each of the original two tables?
parry2k
Super User
Super Userdonovan_smith44 yes it is possible, how you want the output to be? It can be created as seperate table or we can write a column where value is found in both and you can filter on that, so no new table.