Final Friday Fix: March 2023 Challenge
31 March 2023
On the final Friday of each month, we are going to set an Excel / Power Pivot / Power Query / Power BI challenge for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There are no prizes at this stage: you are playing for bragging rights only!
This month, we have a Power Query challenge. We have received some expense information in an Excel workbook which is not in a format that is compatible with our usual layout, viz.
You can download the challenge file here.
Therefore, this month’s challenge is to extract the data from a sheet in the supplied Excel workbook and present it in a Table that can be appended to other expense data. The result should look like the Table below:
Note: Our dates are in UK format – this is not part of the challenge!
As always, there are some conditions:
- this is a Power Query challenge: no Excel formulae allowed
- the solution should allow us to add more expenses
- the solution should need less than 10 steps (one transformation per step)
- All the steps can be achieved using the User Interface (UI) from one query. No M code is needed.
Sounds easy? Then why not have a go? We’ll publish one solution in Monday’s blog. Have a great weekend in the meantime!