Forum Discussion
multi value matrix, selection criteria
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.
So the finish product in a PBI table on the report dashboard looks like the below excel table.
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))
2 Replies
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))