My data contains more than one item for one field. ie.
What i would like to do is understand how many times each potential impact choice was selected. ie. how many time was Resources was selected.
I would then like to display that in some sort of visual chart in a report.
There are up to 7 choices a user can select from and the field is optional so field can be blank also.
Any help appreciated!!
Go to Solution.
@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
View solution in original post
Click here to read more about the November 2022 updates!
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.