Forum Discussion

Simon_Br's avatar
Simon_Br
Helper I
2 years ago
Solved

Table rows in column

Hello,

 

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

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

 

2543000 2543000;45000;85000;1588
2545000 26999;858;4786;4587
2585000   
251588   
26999   
26858   
264786   
264587   

 

Many Thanks for the Help! 

 

 

Best Regards,

Simon

General Comment
  • khaledHabib90's avatar
    khaledHabib90
    2 years ago

    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🙂
     

2 Replies

  • khaledHabib90's avatar
    khaledHabib90
    Resolver II
    2 years ago

    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🙂
     
  • slorin's avatar
    slorin
    Super User
    2 years ago

    with Power Query

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

     Stéphane