Table rows in column

[Simon_Br]

Hello,

I have a challenge and i hope, somewere can help me.

We can i created this table i Power Query or in DAX?

25	43000		25	43000;45000;85000;1588
25	45000		26	999;858;4786;4587
25	85000
25	1588
26	999
26	858
26	4786
26	4587

Many Thanks for the Help! 

Best Regards,

Simon

[slorin]

with Power Query

=Table.Group(YourSource, {"Column1"}, {{"Combine", each Text.Combine([Column2], ";"), type text}})

 Stéphane

[khaledHabib90 · Accepted solution]

If you are looking to concatenate the values then the below should help in dax as a measure:

Measure = CONCATENATEX('YouTableHere','YourTableHere'[ValuesColumn],";")

If my answer helped you solve your problem please accept it as the solution🙂