Power Query insert Rows at change in value using record

[Dicken]

Hello, this is a theory question regarding the anser to inserting blank rows and change in value , the response by alies sx

https://www.excelforum.com/office-36...ml#post5947311

I would like some help in understanding this ;

Please Login or Register  to view this content.

the part i do not understand is "x[c][Item] = c[Item] " , so c = recs {i}[Item] and x[c][Item] = current "item", so is "c[Item]" the
previous or what in an accumulation would be the state?


I have re written this to try and understand how it works to;

Please Login or Register  to view this content.

which works but I don't think is as well, I have attached a workbook with both examples 'gen' and 'gen_mine' and also some other solutions,

if anyone can help or share blog or post with more information on this subject please let me know.
lastly if anyone replies I may not be able to respond for a day or 2 ,
Richard.

[romperstomper]

Yes, c[Item] is the previous row's Item

[Dicken]

I do find this a bit confusing ; compare ;

Please Login or Register  to view this content.

z = y results in all the same but z = [y] = 1 less [x = 4, y = 4, z = 3] , I'm trying to think of [] as the state in accumulation, which helps , a bit.
RD

[romperstomper]

z = [y] is z = _[y] so yes it's the value of the record as it is currently, not the value you are changing it to.

[Dicken]

Thanks, I have not been able to find a lot of information on this;
as far the original insert blank row, and my version ( when tried over 50K + rows) is not that much slower than the other,

i'll leave this open for a bit longer to see if anything more is added, thanks for your help.

Richard.

[6StringJazzer]

Richard, please update your title to correct the typo. I made couple of fixes but can't for the life of me figure out what "chacen" is supposed to be.

I also removed the CODE tags from your link so it is clickable.

[Dicken]

done change, sorry,

[Dicken]

Last word before closing;
I made up these four examples as to the differences in referring to records x as x ,x as [x], z as y, z as [y]

Please Login or Register  to view this content.

[

[Dicken]

This will hopefully be my last comment on this, but found this interesting in illustrating the point

Please Login or Register  to view this content.

[Dicken]

I have attached a sheet with the above as a function and an insert at interval function ;

Please Login or Register  to view this content.