*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
4 ай бұрын
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!
@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!!!
@karimallahwala7022
Жыл бұрын
Thank for sharing and explaining that very helpful „section“
@EricHartwigExcelConsulting
Жыл бұрын
This is awesome! I love how dynamic this is!
@jessontvarghese327
Жыл бұрын
There is no doubt. This is superb coool and awesome overloaded. Thank you.
@roywilson9580
Жыл бұрын
Great video; I can see so many cases where this will be a useful tool to have.
@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.
@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?
@RyanLeishman
Жыл бұрын
That’s pretty useful actually! Would the expand button on the column header then expand and append all tables?
@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
@zahidthakur8725
6 ай бұрын
Quick question. Can we make the a tab reference in a power query dynamic?
@odel_leal
Жыл бұрын
Great information ℹ️ Ypur content is very valuable. I appreciated. Thank you.
@GoodlyChandeep
Жыл бұрын
Glad you think so!
@syrophenikan
Жыл бұрын
Flipping FANTASTIC!!!!! Thanks so much for this. This will help in so many ways. Great job!
@vishalvadalkar8396
10 ай бұрын
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
@leftindependent
7 ай бұрын
Hi 😊 you're doing great job 😊 is it possible to buy a course or something like this just to ask a few questions?
@IvanCortinas_ES
Жыл бұрын
This is very useful in daily work. Thank you Chandeep!!!
@damionc
Жыл бұрын
I am always always learning something new and different with your videos. This is great. 👍🏽
@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?
@arunkumarkesavan6077
Жыл бұрын
Cool of course it will help us... Super Awesome!!!
@GoodlyChandeep
Жыл бұрын
Thank You!
@munawarhussain1400
2 ай бұрын
Amazing function. Not in use now very good to nknow
@ALex-fp2zx
Жыл бұрын
Thanks, wery nice 👍 Dynamizing is always cool!
@davidfelipepenaguardiola1177
Жыл бұрын
Amazing and very very usefull solution. Thanks a lot, Mr Chandeep :)
@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
@Rice0987
Жыл бұрын
Where do you take all of these pearls? 🤔 Do you read manuals and helps? ☺
@aniljaggarwal60
Жыл бұрын
आप पावर क्वेरी में एम कोड सीखने का आसान रास्ता बना रहे हो 😊
@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.
@truptithelonerider5518
4 ай бұрын
Any idea how we can auto refresh dynamic query of API?
@udusegbe
Жыл бұрын
Awesome technique! I have a solution with appends that I definitely will be rewriting 😅
@abhijeetramugade1983
11 ай бұрын
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
11 ай бұрын
www.youtube.com/@desigoodly
@emilmubarakshin49
Жыл бұрын
Thank you so much very cool tip
@Franklinvaz
Жыл бұрын
Thanks for this insight..
@kennethstephani692
Жыл бұрын
Great video, Chandeep, as usual!!
@RoccoCasaburo
Жыл бұрын
You are GREAT
@felipesignorellireis7839
Жыл бұрын
very very gooooood. I love it.
@GoodlyChandeep
Жыл бұрын
Glad you like it!
@mshparber
Жыл бұрын
Supercool!
@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
@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
@Luciano_mp
Жыл бұрын
Good. Thanks!
@doriginal69
3 ай бұрын
Too bad I have an instance where I must merge because of the different columns needed between tables. Unfortunately, append does not help.
@seshakv
Жыл бұрын
Super
@DeronHuskey
Жыл бұрын
Nifty!
@AjinkyaNaramshettiwar-h7n
Жыл бұрын
Hi sir This courses is live courses or recorded
@GoodlyChandeep
Жыл бұрын
recorded
@alexandrus
Жыл бұрын
How to use function or query from another excel file? (not copy, just reference)
@Sumanth1601
Жыл бұрын
Brilliant :)
@tommynguyen4253
Жыл бұрын
Excellence
@GoodlyChandeep
Жыл бұрын
Thanks!
@KuldeepSingh-nq1vi
Жыл бұрын
Nice Video Chandeep, Could you please slow down the pace of speaking..
@brianxyz
Жыл бұрын
You can adjust the playback speed in KZitem to what suits you best. Click on the gear icon to get to the setting.
@excel-in-g
Жыл бұрын
Amazing tip. I see ways how I can use #sections.
@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.
@Koopzy
6 ай бұрын
LITERAL HIGH WIZARD
@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..................
Пікірлер: 66