Forum Discussion
ErnestoMottola
2 years agoNew Member
[Newbie] Rearranging data structure into a new table
Dear DAX users, I am relatively new to PowerBi, and I am trying to rework some data from a Sharepoint list. Basically I have a list of users from various divisions that are allocated to one or mo...
- 2 years ago
hi ErnestoMottola ,
I would advise, keep you data like this only.
This way you can build measures with ease.
Only for Displaying data like below, use one measure in a matrix.
Measure = CONCATENATEX('Table', 'Table'[Champion])
ErnestoMottola
2 years agoNew Member
Thanks, indeed, it seems a measure based on concatenatex would do the trick.
- talespin2 years agoSolution Sage
You're welcome.