Multi Value Matrix

[Anonymous]

I am trying to create a matrix that mimics this excel sheet. It has multiple items that fall in the intersection of two criteria(date and model).  PowerBI only easily lets you show the first, last, or count of these values. Is there a way to show all values in a table? 

[Anonymous]

i am relatively new so either i dont quite understand or should be more specific. I have the below table, and if a "workID" has the same "RoutingID" and same month in "start_cur" as any other "WorkID", i need to concatenate the WorkIDs to be in the same cell. 

[amitchandak · Accepted solution]

@Anonymous ,

Create a new measure and add that to matrix visual value

Routing ID on row and month year and Column

Concatenatex(Table,Table[Work ID], unichar(10))

[amitchandak]

@Anonymous , You can use concatenatex and use all values

concatenate(Table, Table[Column], unichar(10))