Dynamically remove columns in Power Query

preview_player
Показать описание
Use M code to remove unwanted columns dynamically in Power Query
Use Table.RemoveColumns(), Text.EndsWith(), List.Select() in M code

-- Subscribe for more !!
  1. BI Way
  2. power bi tutorials
  3. power bi
  4. Power Query power bi
  5. Power Query in power bi
  6. BI Way
Рекомендации по теме
Dynamically remove columns 0:05:51

Dynamically remove columns in Power Query

DYNAMICALLY Remove All 0:09:04

DYNAMICALLY Remove All Empty Columns with some M MAGIC in Power BI

Dynamically Remove Empty 0:09:58

Dynamically Remove Empty Columns in Power Query

Dynamically remove columns 0:02:57

Dynamically remove columns that contain a specific word in the header - Power Query

Dynamically remove columns 0:05:34

Dynamically remove columns | Power Query | Power BI

Dynamic Remove Other 0:06:22

Dynamic Remove Other Columns in Power Query

Microsoft Power Query: 0:03:59

Microsoft Power Query: Remove empty columns dynamically!

Removing Unwanted Columns 0:05:14

Removing Unwanted Columns in Power Query: A Quick & Easy Tutorial

Week 9 - 1:53:41

Week 9 - Programming Session

Dynamically add or 0:05:01

Dynamically add or remove columns in Power BI | Power BI tutorial

Display columns dynamically 0:03:05

Display columns dynamically using a Slicer in PowerBI | Tutorial | MiTutorials

Hide Columns in 0:02:19

Hide Columns in Power BI | Power BI Tricks & Tutorials

Automatically remove Empty 0:04:37

Automatically remove Empty Columns from a Table in PowerBI | MiTutorials

Remove Columns using 0:02:47

Remove Columns using Power Query in Excel

How to dynamically 0:07:05

How to dynamically remove columns and top rows

Dynamically Re-Order Columns 0:07:57

Dynamically Re-Order Columns in Power Query

Dynamically Remove Empty 0:01:00

Dynamically Remove Empty Columns in Power BI #Shorts

How to add 0:04:15

How to add or remove columns dynamically in a Power BI table or Matrix visual?

How To Choose 0:03:35

How To Choose columns in a Table dynamically with Slicer in Power BI | BI Tricks

Remove Random Null 0:06:10

Remove Random Null Values from Columns in Power Query

Power Query Tip 0:05:38

Power Query Tip for Dynamically Adding Missing Columns

Remove All Empty 0:01:43

Remove All Empty Columns in Power Query

Power BI - 0:00:27

Power BI - Matrix Visualization - move values from columns to rows

Conditionally Show/Hide Matrix 0:06:57

Conditionally Show/Hide Matrix Columns Using Calculation Groups

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

So elegant, thank you! Also very well explained :)

vzmol
Автор

Just what I was looking for! Nice. Thank you.

DP-xzxr
Автор

Liked it and explained very simple and easy to understand. Pl post new videos on power query... Appreciate

syedaneesdurez
Автор

Better practice to create a list of columns to keep rather than a list to remove but still a good tip

thebowrests
Автор

what if my column names are random? For example, I want to keep PO #, order date, ship to...and remove the rest. The reason I want to have it dynamic is everyone may have different column sequence but same name. I want to have to query to allow everyone to drop data source but have same outcome.

jackiegao
join shbcf.ru