Ravindra BagaleCourses & study guides

16. Practice Exercises with Answer Hints

16.9 Module 10: Power Query

By Last updated:

  1. Load tblOrders into Power Query, trim and capitalise City, change Amount to Decimal and load back. Hint: Data › From Table/Range; Transform › Format › Trim / Capitalize Each Word.
  2. Append monthly files January–March from a folder. Hint: Data › Get Data › From File › From Folder › Combine & Transform.
  3. Merge Orders with Stores to bring in the City Manager. Hint: Home › Merge Queries › Left Outer on Store ID › expand City Manager.
  4. Unpivot a sheet with months as columns into Month and Sales rows. Hint: select City › Transform › Unpivot Other Columns.
  5. Load dd-mm-yyyy text dates correctly. Hint: column menu › Change Type › Using Locale… › Date, English (India).

Ravindra Bagale's Tip

Khup students Power Query madhe type change (Changed Type) chukicha hoto te baghat nahit – dd-mm-yyyy tarkha US style samjun 03-04 cha 4 March hoto. Tarkhansathi nehmi Using Locale › English (India) vapra aani Applied Steps ekda varun khali tapasa.