Excel BI Power Query Challenge Workout 031

-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 31-
(Excel formulas also welcome for Power Query Challenges)
– This is the second last problem in the series of FIFA world cup challenges –

Identify the father son duo from the data set of FIFA World cups (some data changed). Following are the criteria

  1. Both should belong to same country
  2. Surname i.e. last name should be same
  3. Minimum difference in years will be 16

Download Practice File - https://lnkd.in/dM92WFpQ

(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