Forum Discussion
Group by columns
Nicole You do not have to do any thing in the data model in order to accomplish this task.
Put all the three columns in a Table visual. Now drag the distance column again and drop it on table visual and chage the aggregation of this column to Count and your task is done.
Hi Malik what if the values we are getting is like dimension domain vaules which need to be clean up with group by and then join the ID column back to a Fact table. to report againts it.
In that case this solution won't work. Any idea for that kind of requierement ?
group by a column and the group item to be shown in comma separated in single column
Have to group by a column and have the group items in coma seprated list in a cloum .
I am importing a sharePoint online list data in my powerBI and the data looks like below
ID Name
1 Pen
2 Chair
2 Table
3 Plug
3 Power
3 shocket
4 Board
4 Marker
4 Eraser
4 Clip
This data need to be tranlate to
ID New Column
1 Pen
2 Chair, table
3 Plug, Power, shocket
4 Board, Marker, Eraser, Clip
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Group By"= Table.Group(Source, {"ID"},
{{"Name", each Combiner.CombineTextByDelimiter(", ")(List.Sort([Name])), type text}})
in
#"Group By"