Check out our newly launched M Language course ↗ https://goodly.co.in/learnmpowerquery/

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/learndaxpowerbi/

✔ Power Query Course
https://goodly.co.in/learnpowerquery/

✔ Master Excel Step by Step
https://goodly.co.in/learnexcel/

✔ Business Intelligence Dashboards
https://goodly.co.in/learnexceldash...

===== 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   / chandeep2786  
LinkedIn   / 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 fulltime 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 AttributionShareAlike 4.0 International (CC BYSA 4.0)
Full license here: https://creativecommons.org/licenses