-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 29-
(Excel formulas also welcome for Power Query Challenges)
– This week is FIFA world cup challenges –
If a country has appeared more than once in finals, find the maximum gap in years for next - previous appearance for that country.
For example, Italy reached into finals in 1934, 1938, 1970, 1982, 1994, 2006. Gap between these years are 1938-1934=4, 1970-1938=32, 1982-1970=12, 1994-1982=12, 2006-1994=12
Maximum gap here is 32 which is for years 1938-1970.
Download Practice File - https://lnkd.in/dKyzZMnu
(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