Dynamic Query Referencing in Power Query 🚀| Using

Подписаться 89 тыс.

Просмотров 19 тыс.

50% 1

Check out our newly launched M Language course ↗️ - goodly.co.in/learn-m-powerquery/
In this video, we will be discussing dealing with multiple Queries. How can we deal with & work with them using Dynamic Referencing!
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/dynamic-query-re...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== CHAPTERS =====
0:00 Intro
0:24 Introduction to the Case
1:41 Getting all the Queries Dynamically
2:51 Converting the Records into Tables
3:51 Picking up the Right Queries
5:15 My Courses
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

Наука

Опубликовано:

29 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 65

@GoodlyChandeep Год назад

*Note - this doesn't work in Power BI but only in Excel PQ environment.*

@OmisileKehindeOlugbenga Год назад

Is there a reason it does not work in PBI? By the way this will improve my ETL significantly. Thanks for sharing.

@sujit3375 Год назад

Why don't you come up with full M code tutorial

@hapticfabric5925 Год назад

Fantastic tips! This is great. It seems to work perfectly in Power BI for me?

@hapticfabric5925 Год назад

Oh I see - it doesn't load to the data model. I wonder why!

@mazin91 18 дней назад

do you have a similar aproach that can work for PowerBI?

@vacilando86 Год назад

You are one of the most productive content creator in this platform , I learned so much from you. Thank you

@Piyush.A Год назад

Excellent video, never imagined this would be even a thing, and yet you're once again diving deep into it!

@EricHartwigConsulting Год назад

This is awesome! I love how dynamic this is!

@roywilson9580 Год назад

Great video; I can see so many cases where this will be a useful tool to have.

@syrophenikan Год назад

Flipping FANTASTIC!!!!! Thanks so much for this. This will help in so many ways. Great job!

@jessontvarghese327 Год назад

There is no doubt. This is superb coool and awesome overloaded. Thank you.

@damionc Год назад

I am always always learning something new and different with your videos. This is great. 👍🏽

@arunkumarkesavan6077 Год назад

Cool of course it will help us... Super Awesome!!!

@GoodlyChandeep Год назад

Thank You!

@karimallahwala7022 Год назад

Thank for sharing and explaining that very helpful „section“

@IvanCortinas_ES Год назад

This is very useful in daily work. Thank you Chandeep!!!

@davidfelipepenaguardiola1177 Год назад

Amazing and very very usefull solution. Thanks a lot, Mr Chandeep :)

@ALex-fp2zx Год назад

Thanks, wery nice 👍 Dynamizing is always cool!

@GeertDelmulle Год назад

Good stuff, Chandeep! Now, I would use a template for all customers, put the files in a folder and work from there, avoiding the issue all together. For several input streams towards, I would make 1 folder + query per stream and combine the streams manually down the -er- flow. Still a good trick and good to know.

@kennethstephani692 Год назад

Great video, Chandeep, as usual!!

@jorstube Год назад

wonderful brother!!! a few days ago I was wondering how to get the name of the query in another query and you just did it; You are a teacher; I was working with a file where the tables are on different sheets and I needed to do a summary in the same book but I didn't want to load tables separately... now I'm going with this improvement. Thank you!!!

@Franklinvaz Год назад

Thanks for this insight..

@emilmubarakshin49 10 месяцев назад

Thank you so much very cool tip

@RoccoCasaburo Год назад

You are GREAT

@odel_leal Год назад

Great information ℹ️ Ypur content is very valuable. I appreciated. Thank you.

@GoodlyChandeep Год назад

Glad you think so!

@mshparber Год назад

Supercool!

@Sumanth1601 Год назад

Brilliant :)

@Luciano_mp Год назад

Good. Thanks!

@aniljaggarwal60 Год назад

आप पावर क्वेरी में एम कोड सीखने का आसान रास्ता बना रहे हो 😊

@udusegbe Год назад

Awesome technique! I have a solution with appends that I definitely will be rewriting 😅

@seshakv Год назад

Super

@felipesignorellireis7839 Год назад

very very gooooood. I love it.

@GoodlyChandeep Год назад

Glad you like it!

@RyanLeishman Год назад

That’s pretty useful actually! Would the expand button on the column header then expand and append all tables?

@DeronHuskey Год назад

Nifty!

@vishalvadalkar8396 6 месяцев назад

Nice to connect-need to know how can we minimize query refresh time-Source data same excel-4-5 tables

@vinhxd0101 Год назад

In case of I have a table from query naming Query_Tab1 in excel file 1. Then I add the extra some column beside of Query_Tab1. I want to get the new data, including the Q_T1 and news extra column to a new table nam wing Tab2. Then combine Tab2 to my report.. Many thanks

@pravinshingadia7337 Год назад

Very good - your videos are avid watching. Could you do a video on automating sorting columns. So have multiple tables with month and year columns which after being appended produce one table but columns are not in month date order. How could you automate this?

@alexj8117 Год назад

This is good, however how to select just one of the available queries? I am sure you could filter for just one of the tables in the list. Some time ago, I found a way (worked with Ken Puls on this) to programatically select a query by its name: (this is in a function). Let me know what you think. (qName) => let qName2=Expression.Identifier(qName), Source = Expression.Evaluate(qName2,#shared) in Source

@txreal2 Год назад

Great video. Btw, how do I load all tables (in one sheet or multiple sheets) in Excel into PQ in one swoop, without checking one by one in Navigator Select Multiple Items?

@leftindependent 3 месяца назад

Hi 😊 you're doing great job 😊 is it possible to buy a course or something like this just to ask a few questions?

@AbhayGadiya Год назад

I think creating custom M function using one data source then putting all the files in folder and importing it PQ and invoke custom function on selected files may be alternative solution.

@tommynguyen4253 Год назад

Excellence

@GoodlyChandeep Год назад

Thanks!

@doriginal69 7 дней назад

Too bad I have an instance where I must merge because of the different columns needed between tables. Unfortunately, append does not help.

@zahidthakur8725 2 месяца назад

Quick question. Can we make the a tab reference in a power query dynamic?

@truptithelonerider5518 23 дня назад

Any idea how we can auto refresh dynamic query of API?

@Waterloo2021 Год назад

Thanks a lot. Is it possible to use recursion in power query, i.e. x(i)=a*x(i+1)+b where x(N) is given

@abhijeetramugade1983 7 месяцев назад

I found it very useful and I am really looking forword to learn more but not understand the video fully due to the English language could you please explain it in Marathi or Hindi.

@GoodlyChandeep 7 месяцев назад

www.youtube.com/@desigoodly

@Rice0987 Год назад

Where do you take all of these pearls? 🤔 Do you read manuals and helps? ☺

@neerajkaushik2800 Год назад

Numeric distribution - How to create measure on multi level also if sum of qty is negative it will be ignore, i have the column like year, month, region, branch, store code, date, product code, distributor code, Sales qty and value, plz help

@excel-in-g Год назад

Amazing tip. I see ways how I can use #sections.

@nirzadhom945 Год назад

Dear Friend. I have one problem. I have this worksheet im developing for my Menu Costing. There's about 60 menus and it might keep expanding with time, and each menu i made on sheet of each with same template of sheet with one another. Each sheet have fixed position of data. Example: Menu Costing, Suggested selling price, current selling price, margin status bad or good. Then i want to make one Summary Sheet which i can view all these data from one master sheet. How can i draw data from this multiple sheet into one master sheet with the challenge the sheet might expand in the future and i want it to automatically insert data to the master list

@KuldeepSingh-nq1vi Год назад

Nice Video Chandeep, Could you please slow down the pace of speaking..

@brianxyz Год назад

You can adjust the playback speed in RU-vid to what suits you best. Click on the gear icon to get to the setting.

@alexandrus Год назад

How to use function or query from another excel file? (not copy, just reference)

@user-wi8wz6bf7c Год назад

Hi sir This courses is live courses or recorded

@GoodlyChandeep Год назад

recorded

@Koopzy 2 месяца назад

LITERAL HIGH WIZARD

@nishantkumar9570 Год назад

You won't believe but I tried it in Power BI and I won't load in Data model.

@nishantkumar9570 Год назад

I've used it Excel.

@ramkumarsai9846 Год назад

Hi @Candeep, I have loved your way of solving so may queries and your explanations. Could you please help on the below Query. Actually the Query is written in Tableau. I need to wright the same logic in Power BI. (in DAX or 'M' Language.) I have Struck in my work. please help me on the same @Candeep If [row_number] = 0 then upper((trim( split (Trim( SPLIT( [COLUMN_NAME], "||",1)),":",1)))) else (trim( split (TRIM( SPLIT([COLUMN_NAME],"||",1)), ":", 2))) END If [row_number] = 0 then upper((trim( split (Trim( SPLIT( [COLUMN_NAME], "||",2)),":",1)))) else (trim( split (TRIM( SPLIT([COLUMN_NAME],"||",2)), ":" ,2))) END If [row_number] = 0 then upper((trim( split (Trim( SPLIT( [COLUMN_NAME], "||",3)),":",1)))) else (trim( split (TRIM( SPLIT([COLUMN_NAME],"||",3)) ,":", 2))) END If [row_number] = 0 then upper((trim( split (Trim( SPLIT( [COLUMN_NAME], "||",4)),":",1)))) else (trim( split (TRIM( SPLIT([COLUMN_NAME],"||",4)), ":", 2))) END If [row_number] = 0 then upper((trim( split (Trim( SPLIT( [COLUMN_NAME], "||",5)),":",1)))) else (trim( split (TRIM( SPLIT([COLUMN_NAME],"||",5)), ":", 2))) END etc..................