Table.TransformColumns in Power Query | Super Function ⚡

Veröffentlicht am: 18 März 2022
auf dem Kanal: 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


Auf dieser Seite können Sie das Online-Video Table.TransformColumns in Power Query | Super Function ⚡ mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer Goodly 18 März 2022 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 61,761 Mal angesehen und es wurde von 1.7 tausend den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!