Forum Discussion
reporting comma separated values in one cell
Hello,
the column has comma separated text i.e. paul, robert, sarah...
In my table visual, I would like to have one row per separated comma i.e
data
------
paul
robert
sarah
how can I do this please? may be in DAX?
Thank you
Use Power Query editor.
Split the column (using comma as delimiter).
Unpivot the columns that have names in them.
1 Reply
- HotChilli
Community Champion
Use Power Query editor.
Split the column (using comma as delimiter).
Unpivot the columns that have names in them.