make 6 row become 1 row

[space83]

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

 

[JYA]

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 · Accepted solution]

Great. I modified your function as below and got the expected results.

List of WO = calculate(CONCATENATEX('Planner Combine','Planner Combine'[Workorder],", "),TREATAS(SUMMARIZE('Planner Combine','Planner Combine'[Weekly Commitment]),'Planner Combine'[Weekly Commitment]))

has any way i want to exclude total of 'List of WO' from the table? 

[space83]

hi @JYA ,

Seems it still not produce an expected result.

actually my table is single table only.

[JYA]

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 : 

[space83]

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]

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.