Forum Discussion
Solved
Dissecting Multi-pick fields
Hi, My data contains more than one item for one field. ie. CR ID Potential Impact 1 Scope, Resources 2 Schedule,Scope,Resources 3 Resources,Cost,Schedule 4 Resources ...
Amy79 , In power query use split by delimiters with row option you will get additional rows for each of the CR ID.
You can use this model to count words
Split Column Power Query: https://youtu.be/FyO9Vmhcfag
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
amitchandak
Super User
Super UserAmy79 , In power query use split by delimiters with row option you will get additional rows for each of the CR ID.
You can use this model to count words
Split Column Power Query: https://youtu.be/FyO9Vmhcfag
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/