Forum Discussion
Solved
row duplication when expanding a table column
In query when expanding a table column, rows duplicate like this: becomes I understand why this happens, but is there any way to instead of duplicating t...
Hi,
Try adding a column in Power Query before expanding the Column 2:
= Text.Combine(Table.Column([Column 2], "Fruit"), ", ")
where "Fruit" is the name of the column in the table that is concatenated and needs to be changed to match your data setup.
Hope this helps,
radpir
Create a measure in DAX like:
Measure = CONCATENATEX(VALUES(Apples[Column2]),[Column2],",")
Create a table visualization of Column1 and this measure.
This did not work - when creating a measure it did not allow this expression, many errors.