Forum Discussion
Helper ICounting string words in semicolon separated column
Hi,
I am trying to count all options selected separated by the semicolon. So for every semicolon marks an additional count. I am excluding all blanks, none and n/a columns. I am not sure how I can achieve this.
Any help would be much appreciated.
4 Replies
- lbendlin
Super User
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
ukare1996Please find attached below - how can I count e.g. the strings in column 1 to return a result of 10 - so count all the strings - each time an occurance of semicolumn signifies an additional count. How do I do this without creating a seperate table and spliting then unpivoting - as I have more these columns in different categories. Any help would be much apprecaited.
Monitor 1 - Action taken by customer40.Monitor 2 - Action taken by customer Monitor 3 - Action taken by customer
Private drains cleaned;#GM UPGRADED following NPO visit/advice N/A GM UPGRADED following NPO visit/advice None None None None None None None None None None None None None None None None None None None None None GM installed following NPO visit/advice None None None None None None None None;#GM installed following NPO visit/advice;#GM UPGRADED following NPO visit/advice;#Private drains cleaned None None None None None None None None None None None None None None None None None None None None Improved kitchen practices GM purchased but not yet fitted GM purchased but not yet fitted None None None None None None Private drains cleaned;#GM - Increased frequency of cleaning GM UPGRADED following NPO visit/advice;#GM (ADDITIONAL) installed following NPO visit/advice Improved kitchen practices;#GM - Increased frequency of cleaning GM installed following NPO visit/advice GM installed following NPO visit/advice GM installed following NPO visit/advice None None None - ukare1996
The count must exclude all None, Nulls and Blanks
