Challenge No. 76: — This week will be FIFA World Cup week.
Solved using: Power Query.
Sum Data Per Week Excluding Weekends
Challenge No. 17: Sum the total sales per Week Excluding Weekends
Dynamic array function allowed but
Extra marks for Legacy Array Functions or PowerQuery Solution.
Solved using: Power Query.
Top 5 Goal Scoring Teams
Challenge No. 75: — This week will be FIFA World Cup week.
Solved using: SQL.
Linear Interpolation!
Challenge No. 97: In the question table, the population data for cities A, B, and C are provided for different years.
Solved using:Excel, Google Sheets, Power Query, Python, Python in Excel, and R.
Avg Interval Between Wins
Challenge No. 74: — This week will be FIFA World Cup week.
Solved using: SQL.
Consecutive Wins Within Span
Challenge No. 21: List the names who have won consecutively at least 3 times within a span of 180 days.
Solved using: Power Query.
Teams Repeated in Finals
Challenge No. 73: — This week will be FIFA World Cup week.
Solved using: SQL.
Top 2 Runner-ups Without Win
Challenge No. 72: — This week will be FIFA World Cup week.
Solved using: SQL.
Sum Visible Rows Using a Criteria
Challenge No. 16: Sum the total sales of the visible cells
NB: Include all “MILK” Product
Dynamic array function allowed but
Extra marks for Legacy Array Functions or PowerQuery Solution.
Solved using: Power Query.
Top 4 FIFA WC Champions
Challenge No. 71: — This week will be FIFA World Cup week.
Solved using: DAX.