Power Query Concatenating a list of Dates

[Dicken]

Hi, I have created a list of dates, which I want to conctenat, but to do this they need to text, so I 've ended up with this;

Please Login or Register  to view this content.

To get list of dates and then

Please Login or Register  to view this content.

My question is can I do this with only one List.Transform statement? I've attached a workbook Query TableA (3) gives best example


Richard.

[rorya]

Yes, you can do two operations in the transform:

Please Login or Register  to view this content.

[Dicken]

Thanks again,

RD

[Dicken]

BTW ,
in my previous post

Please Login or Register  to view this content.

about adding previous and current value and then dividing by current value, which I'd used an index helper and table.selectcolumns, I received this solution,

Please Login or Register  to view this content.

There's a lot in there I don't understand, such as list.RemoveLastN( {0}) ? just thought you mihgt find it interesting to look over.

RD

[rorya]

The {0}&Table.Column(Source,"Unit") part creates a list starting with 0 and then adding on the Unit values. List.RemoveLastN then removes the last item by default so you end up with a list that moves all the Unit values up one and uses 0 to pad the first item.

[Dicken]

Thanks, I've been dissenting the segments to see how they fit together, I may be some time. 😣