-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 37-
(Excel formulas also welcome for Power Query Challenges)
Create the list of Families and their members from the given names.
Family is decided on the basis of common last names.
If there are not more than one person with the same last name, then that person doesn’t belong to any family. Hence,it won’t be listed,
For ex. - David Garcia - Last name Garcia has a single member listed, hence it is not part of any family.
Download Practice File - https://lnkd.in/dY393ufs
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #excel, #excelchallenge
Excel BI’s LinkedIn Post