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.
I should also say that another goal is to simply count the total number of each report type submitted without slicing.
Did you find any solution? I have been trying to solve this exact problem for 1 week already