Challenge No. 278: Transpose the table as shown where sum of amount shown is gross profit which is Revenue – Cost.
Solved using: Python.
ExcelBI Power Query Challenges
Including all the Power Querry challenges designed by Excel BI.
Transpose the data as shown
Challenge No. 277: Transpose the data as shown.
Solved using: Python.
Unpivot the table, add order
Challenge No. 276: Unpivot the table.
Solved using: Python in Excel.
Transpose table, summing values from
Challenge No. 275: Transpose the problem table into result table where value is sum of Values from problem table.
Solved using: Python.
Check ingredient availability for dishes
Challenge No. 274: Problem Table1 contains the list of ingredients which can be used to prepare a dish.
Solved using: Python.
Transpose the table as shown
Challenge No. 273: Transpose the table as shown.
Solved using: Python.
Pick top N by group
Challenge No. 271: From first group, pick up top 1 on the basis of revenue, from second group, pick up top 2 and so on.
Solved using: Python in Excel.
Find all possible routes from
Challenge No. 269: Find all possible routes from City1 to various other cities.
Solved using: Python.
Transpose table: As in one
Challenge No. 268: Transpose the given table as show.
Solved using: R.
Work out tiered running totals
Challenge No. 267: Work out the running total for first 10 entries, then next 9 entries, then next 8 entries till you reach 1 entry.
Solved using: Python.