Chapter -6 Full M Code Power Query - Lists
Full M Code - Power Query Chapter 1- List
#mcode #vikominstitute #excel
00:00 Introduction
00:47 How to Start Power Query
01:55 What is Lists in power query and Type of Lists
05:50 Records in Lists
08:35 How you can enter comments in M code
08:43 Lookups in Lists
13:49 List.Combine in power query
15:40 List.Zip in power query
17:48 List.InsertRange in power query
19:24 List.Distinct in power query
Notes to the video
List
Anything appearing in {}
{1,2,3,4}
{1..5}
{{1,2,},{3,4},{5,6}}
{[Name = “Vikal”],[Rollno = 3]}
Lookup
{1,2,3,4}{2}
{{1,2},{3,4},{5,6}}{0}{1}
{[Name = “Vikal”],[Rollno = 3]} [Name]
Functions
1. List.Combine
2. List.Zip
3. List.Insert
4. List.Distinct
Important Links
Our You Tube channel 👍👍
https://www.youtube.com/c/VIKOMINSTIT...
Our LinkedIn channel 👍👍
/ excel-tricks-vikal-jain-8a011087
Instagram link 👍👍
/ tricksexcel
Telegram link 👍👍
t.me/exceltricks1
Excel group links 👍👍
/ tricksexcel
Twitter link 👍👍
/ vikal10000
Wanna Paid courses 👍👍
Contact whatsapp +91-9213331108 or email info@vikominstitute.com
On this page of the site you can watch the video online Chapter -6 Full M Code Power Query - Lists with a duration of hours minute second in good quality, which was uploaded by the user XLGenAI 11 February 2023, share the link with friends and acquaintances, this video has already been watched 1,369 times on youtube and it was liked by 42 viewers. Enjoy your viewing!
