Forum Discussion
Group Table by Columns creating list for the none grouped column
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...
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
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