Видео

Great video. Thank you!

That was brilliant, you seem to have a knack for visualizing things, I had a go myself before watching, not as neat but; = Table.Group( Table.FromColumns( { List.Combine( Table.ToColumns( Source ) )} , {"A"} ), {"A"} , {{ "N", each [ rc = Table.RowCount(_), acount = List.Repeat( {rc} , rc ) ] [acount] }} ) Then expand ; Tablel.SelectRows, and use [ [column]] to just get the required column.

BA Baracus!!!

Very helpful and informative, but difficult to follow with the double screen because I usually watch these on my phone. Appreciate your expertise, thank you.

Thanks James, not something I would use at the moment but who knows in the future🙂

Excellent and creative as always. Thanks James 👍❤

please make it more simple and understandable , I cant understand this 😔😔🥺🥺

I love it❤

Hi @basensei8699 , Thanks for great video a small notice -) Think need to use Text.SplitAny instead, To catch all Keywords since some values aren't separated by space but "," so we can use Text.SplitAny(Outer[Pattern Sentence]," ,") Space and "," will be consdered, so will get all keywords at first step

You are a genius.

The POWR of RECORDS, Amazing! I learnt a new function List.Repeat. I mostly watch your to understand the problem and try myself then continue to watch how you tackle it, then learn something new always. Here is my solution (my 2 cents): let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], threshhold = 120, t_group = Table.Group(Source, {"PortfolioCode"}, { {"Tbl", each let t = _, t_index = Table.AddIndexColumn( t , "Index", 0 , 1), min_no = List.Min(Table.SelectRows( t_index , each [Cumulative investment Amount] > threshhold )[Index]), t_newcol = Table.AddColumn( t_index , "Col", each if [Cumulative investment Amount] > threshhold then [Index] - min_no+1 else 0) in t_newcol } } ), t_removecol = Table.RemoveColumns( t_group , "PortfolioCode" ), t_expanded = Table.ExpandTableColumn(t_removecol, "Tbl",List.RemoveItems(Table.ColumnNames( t_removecol[Tbl]{0} ), {"Index"} ) ) in t_expanded

Interesting Tip. Thank for sharing

@basensei, do you have a course on M languange? I just found your channel, and you seem to be one the top creators in the subject.

Thank you for the fruitful video but what happens if the first brokerfee exceeds 2000? i guess that you will have a group with one record that exceeds 2000

Is there is any solution for dynamic total for your solution if someone close and load the data then apply filer static total remains un changed or apply any filter after this is the same case too

Excellent content.. loved it.. A tip, the Excel.Workbook function has an additional parameter, by keying in "true" you can skip the promote headers step.

Awesome Video

WOW! Just mind blowing. Never knew that you could use Records instead of the let statement in that context. I remember you did a video before, where you did crazy transformations inside the nested tables using the let statement. Yes Records are better. Learned 2 new fns List.Repeat & List.PositionOf. Being the noob I am, I had to watch this amazing video a couple of times to grasp its real beauty.

I love this but I am clueless how to use this

Subscribed.... Awesome...

Thank you, sir! All other videos I saw (not that many, really) about this 5th parameter comparer used generic x and y and didn't specify, so one never knows if it's current and next or previous and current... Also, everyone but you grouped by a single column, so I wasn't sure if that was the only option!

I'm new to PQE. Hope to see a video on returning the 2nd to last, 3rd to last... record.

Awesome as always. Very creative. Thanks James and lookforward more videos from you. 👍👍

I love the way you teach with such passion and enthusiasm!

Love the energy, i think we are brothers hahaha!!!!

Waouh ! Very high level 😍

Nice use of the Grouping function. Can see a lot of uses for that trick.

kkkkk always the best introduction

Lovely 💪👍

Thanks

Very helpful! Thank you! 👍

Bro, you are genious 😊

I have a situation where I have a parent child relationship in a multiple rows. I need to do a market basket transform where I need to pivot the parent child into one row to see what combinations are selling . Any guidance how could I do that here

Amazing, thank you!

Hi, how do we get the list of the networking days?

Superb

Excellent

Superb

Great Stuff mate

You're always working with Share Market data, so it seems like you have an interest in investing. I'm curious... do you consider yourself a good investor? Have you made it to millionaire status?

Excelletn as always. Thanks James 👍👍

Brilliant as always 👍

Can’t get enough from BA Sensei. Thanks

brilliant, thanks

Amazing! Thank you!

Pretty Good

@3:50 using 2 each statements, the 1st one for the outer (nested) table, and the other for the inner table. The visuals made it so easy to comprehend. The real magic began unfolding at Step6 @4:27 Transform nested table! Your full explanation and step-by-step gradual variable usage made it so clear and amazing. I can't thank you enough! You are the #1 MVP of PQ in RUclips. I swear to Allah. :)

Thanks for that elegant tip of using Folder.Files @1:45. @2:55 I got confused, you used {"Content", Excel.Workbook(_)}; But in video (PQ - Combine Files with inconsistent column names) @1:33 you used {"Content", Excel.Workbook}. Could you please explain when to use (or don't use) the underscore with Excel.Workbook Function? (Thank you in advance.) (I haven't watched this vid till the end yet!)

@ 2:22 = Using Table.ColumnNames(DoubleBarrelHeader) as the 2nd argument (a list) for the Table.FillDown function! That's a new one to me. Table.To(From)Columns functions! Amazing video, indeed. THANK YOU James.

This is great stuff, thx a lot 🙏