There are two duplicate rows, which you can easily find by sorting, but you don’t have to sort when using Power Query. How to label duplicates in Power Query. We don’t want to remove the ...

SELECT b.Id, COUNT(DISTINCT a.UserId) AS users FROM table1 AS a INNER JOIN table2 AS b ON a.Id = b.Id GROUP BY b.Id, a.OtherId HAVING (COUNT(DISTINCT a.UserId) > 1) Executing this query in SQL ...