Power Query Data Structure: Table, Record, List

preview_player
Показать описание
In a short video, I have explained what is the difference between the three main data structures Table, Record, and List to learn more see the below blog by Reza
  1. RADACAD
  2. Power Query
  3. Data Structure
  4. Table
  5. Record
  6. List
Рекомендации по теме
Power Query Data 0:09:29

Power Query Data Structure: Table, Record, List

Power Query Replaces 0:01:00

Power Query Replaces XLOOKUP?!

How to use 0:16:35

How to use Microsoft Power Query

Excel Unpivot Data 0:13:30

Excel Unpivot Data with Multiple Headers (Multiple Row levels into Columns with Power Query)

Understanding Lists, Records 0:03:37

Understanding Lists, Records & Tables Like a Pro! Power Query Basics

Create a Pivot 0:11:02

Create a Pivot Table from Multiple Sheets in Excel | Comprehensive Tutorial!

Combine Files from 0:10:18

Combine Files from a Folder with Power Query the RIGHT WAY!

10 Million Rows 0:10:57

10 Million Rows of data Analyzed using Excel's Data Model

Power Query Challenge 0:09:51

Power Query Challenge 20: Transform Hierarchy Table Structure into Standard Structure

How To Combine 0:11:56

How To Combine Excel Tables And Worksheets With Power Query

Get Multiple Files 0:08:49

Get Multiple Files Containing Multiple Sheets with Power Query

How to Join 0:09:57

How to Join Tables in Excel | Merge or Append Data From Different Sheets Using Power Query

Transform Your Data 0:08:16

Transform Your Data from Single Column To Table Structure POWER QUERY

Power Query - 0:07:44

Power Query - Advanced Dynamic Expansion of Tables

Dynamically Expand All 0:13:07

Dynamically Expand All Columns from Multiple Tables in Power Query

How to Unpivot 0:06:10

How to Unpivot Data with Power Query in Excel

Easily Extract Data 0:08:20

Easily Extract Data from Power Query Lists and Records

How to create 0:12:25

How to create chart data from Power Query | Excel Off The Grid

Don't Make These 0:08:03

Don't Make These DATA MODELING MISTAKES | Data Modeling Best Practices in Power BI | Goodly

Easiest way to 0:10:29

Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)

each & underscore_ 0:09:58

each & underscore_ in Power Query Explained

Effortlessly Combine Data 0:29:20

Effortlessly Combine Data in Excel using Power Query: Step-by-Step Guide

Stack Multiple Columns 0:00:48

Stack Multiple Columns into One in Excel with this TRICK!

Unpivoting Dataset in 0:04:14

Unpivoting Dataset in power query to convert into a long structure

Комментарии
Автор

Veo tus videos son realmente muy buenos!!! muchas gracias por tu tiempo.

hernanmendez
Автор

Good Content, However, I suggest you make another video to showcase the usability of the Record, List and Table.
How we can emphasize their use. Else the above video is just a theory.

sukhomoyb
Автор

Very Nice Explanation.... Thanks Leila

ArifulIslam-gsuy
Автор

We need more about data structure in power query and explain formula in M code such as list.min & table.selectrows

SamehRSameh
Автор

Excellent as always. Thanks a lot Leila.

VictorHugo-bdbf
Автор

Thank you.
How different is #table definition versus Json table created from "Enter Data" option in Power Query? Which one to choose in what scenario?

Bharath_PBI