Group Table by Columns creating list for the none grouped column

[Anonymous]

Looking for some inspiration please.

Within a Dataflow Query I want to group by NAME & Type and for the DATE column replace this with a list which in this example would hold two dates.

What I am trying to do is find where there are records missing (by Date)  so I want to use the List.Differance to find these against a list of know dates so looking for a way to make the list for each distinct Name & Type combination. 

Name	Type	DATE
A	1	01/01/2020
A	1	08/01/2020
A	2	01/01/2020
A	2	08/01/2020
B	1	01/01/2020

NAME	Type	Date
A	1	list (01/01/2020, 08/01/2020)
A	2	list (01/01/2020, 08/01/2020)
B	1	list (01/01/2020)

Thanks in advance.

[Anonymous · Accepted solution]

OK -- figured it out

    #"FTG Step 2: List Dates" = Table.Group(#"FTG Step 2: Make table unique",{"Name", "Type", },{"ActualDates" , each [#"Report Date - TEXT"] ,type list})

This gives you a list in each row.

Note: It needs to be a Text value so you can expand it later

[amitchandak]

@Anonymous ,

No very clear. Refer if this can help

https://docs.microsoft.com/en-us/dax/concatenatex-function-dax

[Anonymous]

Hi,

No concatenatex works across a row what I am looking to do is group a number of rows together like you would with Group By but instead of aggregating i want to create a list of these values.

It is also like pivoting but I don't want to create new columns I want a list of these values.

Regards