Forum Discussion
Expand Multiple Values as One Row
I have a set of data that has multiple values in one field (see below). When I expand that data it creates multiple rows and duplicates the rest of the data. However, this is causing me issues for bo...
Yes you can extract a column from the table here is the syntax:
#"Extract_List" = Table.TransformColumns(#"Removed Columns, {"ProjectLead", each Text.Combine(List.Transform(Table.TransformRows(_,each [Name]), Text.From), ","), type text})Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
I should clarify - it's the "Name" field, I'm trying to get out of this:
Yes you can extract a column from the table here is the syntax:
#"Extract_List" = Table.TransformColumns(#"Removed Columns, {"ProjectLead", each Text.Combine(List.Transform(Table.TransformRows(_,each [Name]), Text.From), ","), type text})
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Hi, I have got a similar situation. My share point is giving person field with multiple people. In powerbi, it is coming as a table. Once I extract values from the table, I have multiple rows
ID 1 Name 1 Red Sunday
ID 1 Name 2 Red Sunday.
I want in my matrix to come as only 1 row
TIA
