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 [email protected]