Power Query Tips to Automate Your Tasks
summary
Shows three concrete Power Query recipes: how to combine files from a folder and promote headers then transpose and split columns so appended workbooks merge cleanly; how to filter by latest file using Date/Time Filters → Is Latest to make refresh pull only the newest upload; how to parse year from filename with Text.Replace then Number.From and Date.From to create a usable date column. Examples include multiplying unit price, rounding, and a live refresh that adds 2020 data.
AI-written summary · about
chapters (8)
- 0:00Start
- 3:42Combine and Transform
- 4:08Fix My Data in Power Query
- 4:41Merge Columns
- 5:17Split Columns by Delimiter
- 7:28A Clustered Bar Chart
- 8:35Applying a Dynamic Filter onto Your Data
- 10:50Split Column and by Delimiter
related talks
58mProductivity Revolution in Excel
48mBest practices for developing Power BI reports
52mPower Up with the Power Platform
01h 04mThe Art of Prototyping Analytics
48mCombine Power BI with External Tools
18mPower BI Quiz Extravaganza
54mLook smarter: deliver your work in Excel
01h 01mHow to Create Value and Present Data to Business Executives in SharePoint