Challenge No. 27: There are 9 clubs and every club has to play with remaining 8 clubs once only.
Solved using: Power Query (Table.AddColumn).
ExcelBI Power Query Challenges
Including all the Power Querry challenges designed by Excel BI.
Generate the result table as
Challenge No. 26: Generate the result table as shown.
Solved using: Power Query.
If in a group of
Challenge No. 25: If in a group of IDs, first occurrence of event Z appears with a category of Temporary, then all Values should be Yes otherwise No.
Solved using: Power Query.
Flag Columns with Special Keys
Challenge No. 24: Generate the result table.
Solved using: Power Query (List.Distinct).
Monthly and Quarterly Sales Difference
Challenge No. 23: Generate the resultant table.
Solved using: Power Query.
Count Daily Swipe Records
Challenge No. 22: Since yesterday’s Power Query Challenge stretched people a lot, here is a lighter challenge.
Solved using: Power Query.
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.
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).
Top Students Subject Order
Challenge No. 19: Generate Top 3 students in all subjects.
Solved using: Power Query.
Count Out-In Quarter Difference
Challenge No. 18: (Excel formulas also welcome)
List the count of quarters for only those rows where Out Quarter > In Quarter.
Solved using: Power Query.