Forum Discussion
jps_HHH
Helper II
Helper IIcount info separated by comma
I ve a database with some info separated by commas and I d like to count the number of I2 , H2, AB, etc
(the result should be: I2 -> 1 ; AB ->11; HQ -> 15 etc)
| book |
| I2, H2 |
| AB |
| H2 |
| LR |
| AB |
| H2, AB |
| H2 |
| AB |
| GH, H2 |
| H2 |
| H2 |
| AB |
| LR |
| GH, H2 |
| AB |
| GH, H2, AB |
| H2, AB |
| H2, AB |
| GH |
| H2, AB |
| GH, H2 |
| GH, AB |
| H2, AB |
| H2 |
| H2 |
Hi, jps_HHH
In Power Query, Split the Column by Delimiter and choose to create new rows.
Then clean/trim the column to remove whitespace and load to PBI.
Create a table and add Count as the 2nd column
Regards
Phil
1 Reply
- PhilipTreacy
Super User
Hi, jps_HHH
In Power Query, Split the Column by Delimiter and choose to create new rows.
Then clean/trim the column to remove whitespace and load to PBI.
Create a table and add Count as the 2nd column
Regards
Phil