Excel Magic Trick 1351: Power Query: Merge Text & Excel Files, Custom Columns, Total Row & Slicer

Download Files: Start File: https://excelisfun.net/files/EMT1351Start.xlsx Finish File: https://excelisfun.net/files/EMT1351Finished.xlsx Using Power Query (Get & Transform), see how to Import & Merge Text & Excel Files, Clean Data, Add Helper Columns for Company Name and Revenue, and add a Total Row & Slicer for Power Query Report: 1. (00:16) Introduction and View of Final Report 2. (02:13) Import Text Files with from Folder option 3. (05:40) Clean Data with Split Feature 4. (06:20) Create Custom Columns (Helper Columns) for Company Name (if then else Function) 5. (08:50) Import Excel Table 6. (10:00) Merge Units Table and Price Table using Left Outer Join (like VLOOKUP in Excel or Relationships in Power Pivot) 7. (12:17) Create Custom Columns (Helper Columns) for Revenue (Number.Round function) 8. (13:55) Edit Query when a Field name is misspelled 9. (15:17) Group By Product & Company Name to get Total Revenue 10. (16:52) Load to Excel Sheet 11. (17:55) Add Totals Row 12. (18:34) Add Slicer 13. (19:26) Why we use Power Query 14. (19:48) Add new Text Files to Folder and Update (Magic of Power Query) 15. (20:53) Summary