Table.TransformColumns in Power Query | Super Function ⚡

Check out our newly launched M Language course ↗️ - https://goodly.co.in/learn-m-powerquery/ Table.TransformColumns function in Power Query has quite a lot of hidden super powers if you decide it customize it. In this video I'll show you 3 interesting applications of Table.TransformColumns. Enjoy ===== ONLINE COURSES ===== ✔️ Mastering DAX in Power BI - https://goodly.co.in/learn-dax-powerbi/ ✔️ Power Query Course- https://goodly.co.in/learn-power-query/ ✔️ Master Excel Step by Step- https://goodly.co.in/learn-excel/ ✔️ Business Intelligence Dashboards- https://goodly.co.in/learn-excel-dashboards/ ===== LINKS 🔗 ===== Blog 📰 - https://www.goodly.co.in/blog/ Corporate Training 👨‍🏫 - https://www.goodly.co.in/training/ Need my help on a Project 💻- https://www.goodly.co.in/consulting/ ===== CONTACT 🌐 ===== Twitter - https://twitter.com/chandeep2786 LinkedIn - https://www.linkedin.com/in/chandeepchhabra/ Email - [email protected] ===== CHAPTERS ===== 0:00 Intro 1:42 Table.TransformColumns Syntax Basics 4:05 Example 1 - Working with IF 7:20 Example 2 - Working with IF + Data Types on 2 columns 13:32 Table.TransformColumns Hidden Feature for handling errors 14:49 Example 3 - Working with Multiple Excel Files 17:53 - My Courses ===== WHO AM I? ===== A lot of people think that my name is Goodly, it's NOT ;) My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI. Please browse around, you'd find a ton of interesting videos that I have created :) Cheers! - - - - - Music By: "After The Fall" Track Name: "Tears Of Gaia" Published by: Chill Out Records - Source: https://goo.gl/fh3rEJ​ Official After The Fall YouTube Channel Below https://www.youtube.com/channel/UCGQE...​ License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) Full license here: https://creativecommons.org/licenses