Forum Discussion
Solved
Count comma delimited data
Hello, I have a data dump whereby some fields can have more than one type in the same occurrence and other fields are multi-select which can give multiple categories in the same occurrence. I wan...
Hi,
I do not have a fancy way to solve this. All i can suggest is that we create two tables fro your source as shown below. I have done so by using the Split column > By rows feature of Power Query.
Hi,
Do not split the data by columns. SPlit it by rows as suggested in my previous post.
but then the data will no longer be 'per occurrence'
Hi,
I believe it will if you use the the DISTINCTCOUNT() function.