Forum Discussion

space83's avatar
space83
Icon for Helper IV rankHelper IV
4 years ago

make 6 row become 1 row

Hi all,

 

This 2 table below actually come from same table in model.

How can I show the 2nd table (workorder) in table 1 as new column in 1 row and separate by comma?

 

as example it will be something like below:

 

Count of Workorder | Workorder

6 | 2021025087, 2021025098, 2022002469, 2022005246, 2022007304, 2022007706

 

Need Help
Show and Tell
Tips and Tricks

5 Replies

  • JYA's avatar
    JYA
    Frequent Visitor
    4 years ago

    Hi, 

     

    you can add a measure of this kind : 

    Workorder full = CONTATENATEX('WorkOrder','Workorder'[Workorder], ", ")
    Of course you need to filter on same key but you have not provided it in your message. 

     

  • space83's avatar
    space83
    Icon for Helper IV rankHelper IV
    4 years ago

    Hi JYA,

    actually the data was group to 3 column in red crop below.

    i try use u formula sir but seems its not work.

     

    I  think is better if i able attach my pbix file but seems this forum dont have that features.

     

     

  • JYA's avatar
    JYA
    Frequent Visitor
    4 years ago

    If I reproduce your tables with Article Nr as the key, you should get : 

    Workorder =
    CALCULATE(CONCATENATEX(Workorder,Workorder[Workorder],", "),TREATAS(SUMMARIZE('Table Machines','Table Machines'[Article nr.]),Workorder[Article nr.]))
     Table Machines : 

    Workorder :

     

     

    • space83's avatar
      space83
      Icon for Helper IV rankHelper IV
      4 years ago

      hi JYA ,

       

      Seems it still not produce an expected result.

      actually my table is single table only.

      • JYA's avatar
        JYA
        Frequent Visitor
        4 years ago

        Ok, 

        I have created the table with only Article nr. and Workorder :

        Planner Combine = DATATABLE("Article nr.",STRING,"Workorder",STRING,{{"MY10290.1","2021025087"},{"MY10290.1","2021025098"},{"MY10290.1","2021025468"},{"MY10290.1","2021025246"},{"MY10290.1","2021025304"},{"MY10290.1","2021025706"},{"MY10950.1","202102000"},{"MY10950.1","2021025001"},{"MY10950.1","2021025002"}})
         
        and using 
        Workorder list =
        CONCATENATEX('Planner Combine','Planner Combine'[Workorder],", ")
         
        Create table like this 

        Count of Workorder is distinctcount

        I get this :