Forum Discussion
Multi Value Matrix
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, o...
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))
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.
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))