Forum Discussion
Visualisation option that allows for text format data to be used as table/matric values.
maracles , Not very clear. But you can create measure using concatenatex and use that
Concatenatex: https://www.youtube.com/watch?v=du2HSEzng2E&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=43
concatenatex(Table, Table[Column], ",")
maracles , Not very clear. But you can create measure using concatenatex and use that
Concatenatex: https://www.youtube.com/watch?v=du2HSEzng2E&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=43
concatenatex(Table, Table[Column], ",")
Thanks amitchandak - sorry it wasn't clear. If this helps I'm trying to produce a Matrix like the below:
My data is in two tables:
1. Departments
2. Roles
The data relationshipis one to many, with each Role linking to only one Department, but each Department having many Roles.
I just figure out to have the Roles as the value in the table. Does ConcatenateX help in this scenario?