Power Query (Excel) | Dynamic Filtering & Parameter

preview_player
Показать описание
This video will show you how to filter with Parameter and Power Query function and M code.

Topic:
0:00 - Intro
0:30 - Filtering with Parameter
1:31 - Filtering with Merge function
2:46 - Filtering with M Code (Table.SelectRows; List.Contains; List.Buffer)
3:37 - Wrap up
  1. Bsmart2gether
  2. Microsoft Excel
  3. Ms Excel
  4. PQ
  5. Power Query
  6. Automation
Рекомендации по теме
Combine Data from 0:12:29

Combine Data from Multiple Excel Files | Most Dynamic Method (Dynamic Columns & Sheets)

Power Query and 0:03:06

Power Query and Dynamic Arrays

Create a Dynamic 0:13:18

Create a Dynamic File Path in Power Query

Power Query (Excel) 0:03:45

Power Query (Excel) | Dynamic Filtering & Parameter

Power Query Parameters 0:12:14

Power Query Parameters - Dynamically Change the Output of Your Queries Depending on Their Value

Filter by Parameter 0:10:50

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

You WON'T BELIEVE 0:12:17

You WON'T BELIEVE These 10 HIDDEN Features in Excel Power Query 🤯

Power Query - 0:05:03

Power Query - Dynamic Merge (Part 1)

🔥 How to 0:50:34

🔥 How to Create an Animated Dashboard in Excel with Power Pivot. #Excel #VBA and #SQL

Making queries dynamic 1:08:38

Making queries dynamic in Power Query with Rick de Groot

Expand columns dynamically 0:12:45

Expand columns dynamically in Power Query (THE RIGHT WAY!) | Excel Off The Grid

Dynamic Query Referencing 0:06:04

Dynamic Query Referencing in Power Query 🚀| Using #sections in Power Query

MSPTDA 20: Query 0:11:07

MSPTDA 20: Query Parameter for Dynamic Folder Location / Data Source in Power BI & Excel Power Q...

Combine Files from 0:10:18

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

Dynamic SQL queries 0:04:23

Dynamic SQL queries with Power Query (Can be used for Excel and Power BI) - WHERE Conditions

Power Query parameters 0:12:29

Power Query parameters | Add flexibility to your queries | Excel Off The Grid

INSANE AMAZING Power 0:05:38

INSANE AMAZING Power Query tip to quickly change data sources in Power BI and Excel

Consolidate & Clean 0:09:06

Consolidate & Clean Multiple Excel Sheets in One Pivot Table

Dynamic Column Names 0:09:24

Dynamic Column Names in Power Query

Power Query and 0:13:32

Power Query and Dynamic Arrays… The Excel Dream Team For Extracting Records

Dynamically Re-Order Columns 0:07:57

Dynamically Re-Order Columns in Power Query

7 METHODS to 0:05:59

7 METHODS to change source data location in Power Query | Excel Off The Grid

4 METHODS to 0:13:14

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

Data Loading Tricks 0:10:26

Data Loading Tricks in Power Query

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

Hi KT, thank you very much for the insightful tutorial. Could we also use a simple Table.Join (defaulting to an InnerJoin, so returning only the matching rows from the two tables) as another filtering option?

SaaaAaaah
Автор

Please Share your exercise file . would please slowly present your topic, hope it will help us to catch your informative presentation.

RafiqulIslam-bpb
Автор

Hi,
When list.buffer must ill used? Is first time that i see ...
Excuse my english...
From Brasil

danielgoncalveslima
Автор

Thanks for this tutorial, but i feel this tutorial too fast in presentation so i must pause to try understand it. Maybe my mother language not english....lol

winartas