Chapter 4, exercise 4-3

Book Q&ACategory: Chapter 4Chapter 4, exercise 4-3
Niels asked 3 weeks ago

After completing this exercise, I found it strange that both in my file as the solution file the column "list price" only contained values for the accessoires parent category.

I think this is caused by the value in cell E1 of C04E03 – Accessories.xlsx from the freshly downloaded zipfile on https://www.microsoftpressstore.com/store/collect-combine-and-transform-data-using-power-query-9781509307951

This cell contains a space before the underscore, if you remove it and refresh the query, the column is filled for all categories.

Leave a Reply

1 Answers
Best Answer
Gil Raviv answered 3 weeks ago

Hi Niels,

You are correct. We will update the relevant file C04E03 – Accessories.xlsx soon. This is a great example for the challenges of mismatched columns 🙂

Thanks,

Gil

Leave a Reply

Your Answer
17 + 7 =

Accept types: pbix\xlsx\pbit\zip

Add another file