Concatenate list of dates in power query

[Dicken]

Hello all,

I have a query which is grouped and the last part is a list of dates which I'd like to join together,
I've tried Text.Combine, but this doesn't seem to work with dates so I tride nesting Text.FromDate, no good, or I'm not using it correctly which is more than possible.

So I'm stuck at this stage;

Please Login or Register  to view this content.

I've attached a workbook which has a pivot table showing what I'd like to achieve in power query.

[alansidman]

See if this works for you. Not as neat as the Power Pivot Solution you provided.

Please Login or Register  to view this content.

[Dicken]

Hmm,
Not quite what I was hoping for ;
I was looking more for something like ;

Please Login or Register  to view this content.

but something that would work for a date

RD

[alansidman]

Your code in the file, slightly tweaked gets the same result as the Pivot Table.

Please Login or Register  to view this content.

Pivot table is the top presentation and PQ is the lower presentation

Excel 2016 (Windows) 64 bit

	B	C
3	Product	Sale Dates
4	a	01/02/2020 , 06/02/2020 , 04/03/2020 , 01/05/2020
5	b	06/02/2020 , 04/03/2020 , 01/05/2020 , 03/04/2020
6	c	01/05/2020 , 03/04/2020
7	Grand Total
8
9	Product	What Date
10	a	01/02/2020, 06/02/2020, 04/03/2020, 01/05/2020
11	b	06/02/2020, 04/03/2020, 03/04/2020, 01/05/2020
12	c	03/04/2020, 01/05/2020

Sheet: PTable.

[Dicken]

Thanks Alan,
that works, now all I've got to do is understand it. Not used Text.From before, apart form MS DOCS , any suggestions

Richard.

[Dicken]

Hi,
meant to add is it possible to put it inside the original grouping , it certainly works,
MS docs it's usual help , Text.From(3) = "3", well yes, but you I think are apply it to each 'step', and I can't see where it's getting
it's source from? is it the just the Date or the entire table that's being transformed to text. I don't expect lengthy explanations but if
you could point me in the direction of some online reading that would help.

Thanks,
RD

[Dicken]

Hi alan,
Just as a follow up ,
I did just type the whole lot in the formula bar ,

Please Login or Register  to view this content.

and as you can see had to replace the Transform( _ , with the acutual [name]

Just thought might be of interest.

RD