Challenge No. 22: Since yesterday’s Power Query Challenge stretched people a lot, here is a lighter challenge.
Solved using: Power Query.
⭐️⭐️⭐️ Intermediate
Moderate difficulty level.
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.
Avg Interval Between Wins
Challenge No. 74: — This week will be FIFA World Cup week.
Solved using: SQL.
Teams Repeated in Finals
Challenge No. 73: — This week will be FIFA World Cup week.
Solved using: SQL.
Top 4 FIFA WC Champions
Challenge No. 71: — This week will be FIFA World Cup week.
Solved using: DAX.
Consecutive FIFA Wins and Years
Challenge No. 69: — This week will be FIFA World Cup week.
Solved using: SQL.
Mismatch Fields Per Employee
Challenge No. 20: There are two rows per Emp ID which are from two different sources.
Solved using: Power Query (Table.AddColumn).
Advanced Lookup Data Separated by a Carriage Return
Challenge No. 15: Extract the least performed subject and marks
Dynamic array function allowed
but Extra marks for Legacy Array Functions or PowerQuery Solution.
Solved using: Power Query.
Last Inventory Level!
Challenge No. 95: In the Question table, monthly inventory levels of products are provided.
Solved using:Excel (BYROW, FILTER, HSTACK), Google Sheets, Power Query (List.RemoveNull, Table.AddColumn, Table.Group), Python, Python in Excel, and R.
Lookup and Get the Difference
Challenge No. 14: Rules:
Check Salary within Scale Table
If Exact within the table, (Salary-previous year Amount)
If between 2 years, get the difference between the two years
If No Previous Year, Return Zero
Strictly Legacy Array Functions or PowerQuery.
Solved using: Power Query.