Dynamically Find a Column Header in Power Query | Dynamically Select Column Header In Power Query

preview_player
Показать описание
Dynamically find a column header and promote them in power query is a very common requirement, specially if you are importing data from excel. In this video we will see how to dynamically select header row of data in power query.
======================================================
This video solves below queries.
1. How to dynamically select header row of data in power query.
2. Dynamically find a column header and promote them in power query.
3. Find table headers in power query .
4. Power query dynamic column headers.
5. Power query dynamic column reference.
6. Power query dynamic column name.
======================================================
Also take a look at more videos
1. Power Query Tricks and Tips Playlist
2. Power BI Dashboard Tips Playlist.
3. Power BI DAX Real Life Scenarios & Tricks
4. Smart Excel Tricks & Tips.
======================================================
Рекомендации по теме
Комментарии
Автор

This is an excellent video for dynamic headers. Genius level!

bamakaze
Автор

Thank you. Its Solved.... But is there any other option to get header change...?

chantialiens
Автор

Hi, great video! I did it the first time and it works great! thanks!

piajavier
Автор

Thank you very much for your video, but what happens if I have a data set where I don't know which column has the "Brand" row for the filter. ie. .., each [Column1] = "Brand", can you dinamically specify the column where Brand is?

ramonillarramendi
Автор

It is nice video, but this is dynamically selects rows not columns...

nataliaedge