Magic of Power Query-Getting column headers from multiple header rows with merged columns Power BI

preview_player
Показать описание
#POWERBI #MICROSOFT #MICROSOFTPOWERBI #DAX #MICROSOFTPOWERBIDATAANALYSIS, #DATAANALYSIS, #BUSINESSINTELLIGENCE #BI #PERYTUS #DECIPHERYOURDATA #POWERQUERY #POWERQUERYLISTFUNCTIONS #LIST.ZIP #LIST.TRANSFORM #TABLERECORD #DATATRANSFORMATION #MFUNCTIONS

In this video, learn a technique to get table column headers when an Excel file has multiple header rows and also if header rows contain merged columns.

Also, we will explore various Power Query "M" List functions like List. Transform, List.Zip, get record from a table using record number, etc. This video gives you a flavor of writing "M" code in the advanced editor and shows the "M"agic of Power Query on how to solve the common data preparation challenges.

Enjoy!!

  1. PeryTUS - Power BI How To
  2. power bi
  3. power query
  4. power bi desktop
  5. power bi tutorial
  6. business intelligence
Рекомендации по теме
Magic of Power 0:17:05

Magic of Power Query-Getting column headers from multiple header rows with merged columns Power BI

Magic of Power 0:01:32

Magic of Power Query-Getting column headers from multiple header rows with merged columns Power BI

Column of Records 0:06:57

Column of Records into Table. Power Query. 2 Methods. Excel Magic Trick 1717

Extract a column 0:04:42

Extract a column of data from a Power Query table

The Magic of 0:10:28

The Magic of working with Records in Power Query

The Magic of 0:14:27

The Magic of Working with Lists in Power Query

The Magic of 0:10:17

The Magic of Records in Power Query || Display Advanced Calculations Step-by-Step

E-DAB 06: The 0:26:40

E-DAB 06: The Magic of Power Query to Import, Transform & Load Data

Advanced Concatenate/ Merge 0:06:25

Advanced Concatenate/ Merge columns with Power Query

Power Query Trick 0:00:50

Power Query Trick ✅ Add Multiple Columns in 1 Go!

Keep most recent 0:02:16

Keep most recent record on a table with Power Query | Improved solution

Excel Magic Trick 0:21:20

Excel Magic Trick 1351: Power Query: Merge Text & Excel Files, Custom Columns, Total Row & S...

Everything about Power 0:00:27

Everything about Power Query M Functions #powerbi #shorts

Refer to a 0:04:22

Refer to a value, column or row in Power Query

32 - Add 0:07:52

32 - Add Column from Examples in Power Query in Excel

The Magic of 0:12:34

The Magic of Power Query & Hidden Pivot Table Trick. Don't Miss it

Power Query Running 0:04:39

Power Query Running Count with Grouping & Add Index - Excel Magic Trick 1589

Power Query Tip 0:05:38

Power Query Tip for Dynamically Adding Missing Columns

Power BI PowerQuery 0:03:17

Power BI PowerQuery - Get the Latest Date using List.Max

Stack 2 Columns 0:06:47

Stack 2 Columns (Append). INDEX Function or Power Query? Excel Magic Trick 1644.

Power Query Running 0:07:25

Power Query Running Count Based on Row Condition – Excel Magic Trick 1588

How Power Query 0:09:02

How Power Query Will Change the Way You Use Excel

How to use 0:16:35

How to use Microsoft Power Query

Excel Text in 0:20:48

Excel Text in Pivots and Power Query Magic

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

Sir you earned as subscriber for providing solution for complex scenario

ranjantiwari
Автор

This is what I was looking for, thank you so much

ranjantiwari
Автор

We all love your videos on Power BI and Power Query. I an a regular follower of oyur videos and content. The way you explain the issue and usage of each function is amazing. One small request that Could you please share .PBIX File to practice or else can you give access to these .PBIX Files if they are available on your website. Please reply back with your response to this request

NaraMeerammaTrust
Автор

PLEASE TAKE A SESSION ON MAT CALCULATION YEAR WISE..LIKE (AUG'21-JULY22, AUG'20-JULY21, AUG'19-JULY20, AUG'18-JULY'17), GROWTH( %)YEAR WISE FOR MAT CALCULATION..MOVING ANUAL TOTAL

balramprakash