Відео

How useful, thank you for sharing!

That meta tip is gold. Thank you

getting error in last step :Expression.SyntaxError: Token Comma expected. code = Table.TransformColumns(Source, {}, each List.ReplaceMatchingItems({_}, Find_Replace List){0})

Dopeeeee!!!!!

I think the first step needs to be, "Make sure your data is sorted by date, in ascending order." If the data isn't presorted, the code won't work as expected.

Excellent as always. Thanks James .👍❤

Lost money in Herbalife? 🤣

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.

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 :)

I enjoyed that. Cheers

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

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

Amazing stuff

THANK YOU!! Your video is the ONLY one that solves this aggravating issue!!

I got error when setting sorting each level. I created new column of Index for each level. Error showed about more than one value relation. Do you know how to fix it?

Awesome tutorial and explanation! This underscore trick is so cool to make your M-code cleaner.

Excellent solution. The List.Accumulate function is not very easy, but is important to know it. Thank for sharing

Excellent! Most solutions out there start with a merge query which might not be applicable when there is no common column between the two tables.

This is fantastic, thanks a lot man

Thank you! I appreciate the sophisticated example.

Am I correct in saying that this creates a record and then references that record?

💖@1:07 "I love Power Query, by the way." Me, too! And your videos are helping me love it even more! Thank you!

This is sooo good! Thank you! 🙏

Brilliant!

This is gold. Not only does it solve the issue itself, but taught me a simple approach to do a nested 'let... in'. This will come in handy for a lot of different issues!!! Thank you very much!

Hi Sensai, could you please let me know whether this is possible in pq I have two tables in powerquery One table -Custreview ProductId, customer-comments 100, it sucks 102, this is amazing Second table -custmoderate ProductId, lookupword, replaceword 100, sucks, not good 100,it, this 102,amazing,exemplary From Custreview table match Product Id with custmoderate table; if matched; take customer comments field from Custreview and replace lookupword with replaceword. One Product Id can have 100's of word that need to be replaced. Please guide me how to do it in powerquery.

Thank you dude. Your tutorials always rock.

How can you create a library of custom functions?

bro is a hero way better than whatever they're doing in stackoverflow

So simple, so fast! You are AMAZING!

Plz zoom in the screen in next videos

Can i use this to draw a performance chart

Hey James, I've got a bunch of .pspc files from AutoCAD Plant3D. I can open them in “SQLite Expert Personal 5 - 64bit” and see a list of tables, but I specifically need data from the “EngineeringItems” table in each spec file. I'm attempting to use Power Query to link to a folder containing these files, but when I try to expand the binaries, it doesn't recognize the .pspc format. I've tried searching ChatGPT and UA-cam for solutions, but I'm just getting more confused. Do you happen to know any magical way to connect to an unknown file format? 😊

Great deal man! do you have other content where you can show who are actually the lost custumers. Their names! so you can track efforts with de sales team.

brilliant!

I love these non pivot solutions to pivoting.

That is brilliant, and I'm still working on understanding how it all fits together, but I did have a go myself, this did mean having a unique date or index column, then Table.SelectRows( <= current index, then take the values as a list and List. transform those that meet condition to 1 or else 0, then sum , not quite as good at does repeat if the previous value if the condition isn't met. Now off to watch 'column groups to rows' . 😊😊

You are just amazing man, concepts and solutions you bring are out of the box...

Another great video, would like to hear the real-world situation that prompted this. Seems like a strange thing to need to accomplish.

So in a record you squeeze 2 integers, 1 list and 1 table... Nice! I want you do it (same outcome) with nested LET, to really make a point.

Looks interesting but I'm going to have to work through that quite a few times to understand what is happening in each step.

amazing video

Thank U very very much!!!

Man! You are really Cool! Thanks a lot!!!

Great video! Thanks for all your content! I've been looking for a way to pull in a value from the 'outer table' into my nested table for hours. All examples seem to have to add a new column to the outer table first. Is there a way to add the "PortfolioAndSource" column in your example directly to the nested table? - Best.

You are awesome

Brilliant! Thanks James ❤👍

Great as usual but I'll have to go through it a couple of times to work it out!

The "meta" trick is very useful in some situations, but it should come with a big warning that if you add steps to the end of the query containing the "meta" statement, you have to manually cut/paste that part to the end of whatever the new "last step" is. Otherwise, any queries that depend on that meta step will break. Unfortunately, it isn't one of those persistent things that automatically updates the M code when you add more steps 😒

This is a great video but there is one thing that is not quite right. You say that Text.TrimStart(_, {",","."}) removes ALL the commas and periods but that not true. This function only removes the leading commas and periods. Any trailing commas and periods remain. Trailing commas and periods can be removed with Text.TrimEnd. To remove all commas and periods in one go, it is probably best to use Text.Remove or Text.Trim.