cancel
Showing results for
Did you mean:
Highlighted
Resolver II

## Find the match between two lists and columns

I have two lists or columns. One with the answers made by some people (LIST_1) and the second with the correct alternatives (LIST_2). How can I, in POWER QUERY, return the number of lines that match?

I speak list or column, because I would imagine that finding the lines that coincide as a list would be the best way. But, if possible as a column, it can also be useful.

Sample

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Supplier

## Re: Find the match between two lists and columns

``````let
List_1 = {"E", "B", "C", "B", "E", "B", "C", "E", "E", "C", "A", "E"},
List_2 = {"A", "A", "A", "B", "C", "D", "E", "B", "D", "C", "A", "B"}
in List.Count(List.Select(List.Zip({List_1,List_2}),each _{0}=_{1}))``````

If my code solves your problem, mark it as a solution

ziying35

4 REPLIES 4
Super User V

## Re: Find the match between two lists and columns

Try this m code:

let
List_1 = {"E", "B", "C", "B", "E", "B", "C", "E", "E", "C", "A", "E"},
List_2 = {"A", "A", "A", "B", "C", "D", "E", "B", "D", "C", "A", "B"},
Match = Table.RowCount(Table.SelectRows(Table.FromColumns({List_1, List_2}), each [Column1] = [Column2]))
in
Match

Proud to be a Super User!

Highlighted
Solution Supplier

## Re: Find the match between two lists and columns

``````let
List_1 = {"E", "B", "C", "B", "E", "B", "C", "E", "E", "C", "A", "E"},
List_2 = {"A", "A", "A", "B", "C", "D", "E", "B", "D", "C", "A", "B"}
in List.Count(List.Select(List.Zip({List_1,List_2}),each _{0}=_{1}))``````

If my code solves your problem, mark it as a solution

ziying35

Highlighted
Resolver II

## Re: Find the match between two lists and columns

Wow!! I didn't know List.Zip.

Thanks @ziying35 !

Highlighted
Resolver II

## Re: Find the match between two lists and columns

Hey @PietroFarias ,

We can achieve this using this simple technique also:

Exepected Output:

Step1 : Add a conditional column

Enter the details as shown in the picture

• New column name= Result
• If Column Name = Students Answers (Column)
• Operator= Equals
•

In the value's list Select a column

• Output = Correct
• Else = Not Correct

Then Click on OK

Result

Thank you