Power Query - Filter Multiple Columns at once🦖😶‍🌫️

preview_player
Показать описание
In this video i show you how to use some list functions to quickly filter multiple columns in one go. #data #dataanalytics #powerbi #powerquery #excel #mquery 🦖😶‍🌫️

Follow along file:

Functions Used
To add columns to a Table
Table.AddColumn

To check for specific values in lists
List.ContainsAny

To check for true or false matches in lists
List.MatchesAny
  1. BA Sensei
Рекомендации по теме
Power Query Tip 0:04:21

Power Query Tip for Filtering Multiple Columns on Multiple Values

Filter Data with 0:14:37

Filter Data with Multiple Criteria using Power Query

Power Query: Filter 0:04:49

Power Query: Filter Multiple Columns at Once

4 METHODS to 0:13:14

4 METHODS to Filter by a List in Power Query | Excel Off The Grid

Filter Multiple Values 0:02:33

Filter Multiple Values in Power Query by taik18

Mastering Multiple Filter 0:06:23

Mastering Multiple Filter in Power Query by taik18

Dynamic Filter Multiple 0:05:16

Dynamic Filter Multiple Values in Power Query by taik18

Filter by Parameter 0:10:50

Filter by Parameter and Dynamic Drop-Downs with Power Query | Everyday Office

RAGChat: Optimal retrieval 1:06:16

RAGChat: Optimal retrieval with Azure AI Search

Filter Table based 0:00:36

Filter Table based on Multiple Values in a List in Power Query

Using One Power 0:11:35

Using One Power Query Table to Filter Another Power Query Table | Multiple List Parameters

How to use 0:07:51

How to use IN or NOT IN filters in Power Query? | Multi-value filter in Power BI | BI Consulting Pro

Can you use 0:04:16

Can you use Power Query Dynamic M Parameters for multi-select?

Filter Nested Tables 0:12:58

Filter Nested Tables before Expanding in Power Query

How to Filter 0:05:29

How to Filter Data in Excel with Power Query and Multiple Criteria

Dynamic Filter by 0:06:02

Dynamic Filter by a Range of Values in Power Query

Power Query Advanced 0:05:22

Power Query Advanced Filter with Multiple List of Criteria

Filter your Power 0:04:03

Filter your Power Query columns by ANY CONDITION!

Filter multiple columns 0:02:49

Filter multiple columns simultaneously in Power BI (advanced filter)

Power Query - 0:05:16

Power Query - Filter Nested Table Before Expanding

DAX CALCULATE Trick 0:10:12

DAX CALCULATE Trick to Pass Filters from Many to One Side of Relationship

How to filter 0:03:57

How to filter a table to show only most recent date by group in Power Query

How to sort 0:02:43

How to sort multiple columns using the M Language in Power Query

Easily Compare Multiple 0:11:12

Easily Compare Multiple Tables in Power Query

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

I like it. The first example is instructive in its use of the List.MatchesAny and Text.Contains functions, but there is an easier way to go to achieve same result. Just use List.Contains. More specifically, each List.Contains({[Stock], [RecentActivity], [PortfolioName]}, "none", Comparer.OrdinalIgnoreCase)),

garywilhelm
Автор

You are the BEST MASTER! Thank you ! You always takes best examples and this is most important for better understanding !

ВиталийШубин-кэ
Автор

Magic 🪄🪄 plz we need more about theses formula because no one explain it

SamehRSameh
Автор

Hi sir, I am Avinash from India. My problem is that I want to group my entire dataset (which I have already prepared in Power Query and set to connection only) based on one column. I want to display another column from the same dataset, which contains text descriptions, as a heading title for each group. I haven't found a video on the internet that shows how to do this. Please make a video on this.

avinashverma
Автор

Ok. What if in FilterMulti at
each List.ContainsAny({[RecentActivity], [PortfolioName]}, {"Hold", "Bill Ackman"})),
we also want "hold" and "bill Ackman"?
Do we use each List.MatchesAny and an OR ??
Thanks. Please show me how :)

txreal
Автор

Why are you wearing a woolly hat in a heat wave ? 🥵🥵🥵🥵

snipelite