I have two tables in Power Query City and People.
CITY
Id, Name
1, Brisbane
2, Sydney
3, Melbourne
PEOPLE
Id, Name, CityId
1, Jay, 1
2, Sam, 2
3, Paul, 1
4, Sarah, 3
I'd like to add a column to City that shows a count of how many people belong to that city.