Table.TransformColumns in Power Query | Super Function ⚡

Published: 18 March 2022
on channel: Goodly
61,761
1.7k

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-dash...

===== 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 - goodly.wordpress@gmail.com


===== 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


On this page of the site you can watch the video online Table.TransformColumns in Power Query | Super Function ⚡ with a duration of hours minute second in good quality, which was uploaded by the user Goodly 18 March 2022, share the link with friends and acquaintances, this video has already been watched 61,761 times on youtube and it was liked by 1.7 thousand viewers. Enjoy your viewing!