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 som...
Need Help
Show and Tell
Tips and Tricks
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 :