Forum Discussion

BPelzel's avatar
BPelzel
Frequent Visitor
4 years ago
Solved

Multiple Values Same Column

We receive data from a survey that has a question with a list of values. People taking the survey can choose multiple values for the question. When we receive that data in an Excel spreadsheet, it a...
Need Help
  • v-angzheng-msft's avatar
    v-angzheng-msft
    4 years ago

    Hi, BPelzel 

     

    1. Try to split cells into rows with commas and line breaks in PowerQuery.

    2. And delete the extra spaces before and after the value.

     

    Data:

    Steps:

    data:

    Then to create a measure to count the fruit.

    _count = COUNT('Table'[data])

    Result:

    Please refer to the attachment below for details. Hope this helps.

     

     

    Best Regards,
    Community Support Team _ Zeon Zheng
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
4 years ago

Hi, BPelzel 

 

1. Try to split cells into rows with commas and line breaks in PowerQuery.

2. And delete the extra spaces before and after the value.

 

Data:

Steps:

data:

Then to create a measure to count the fruit.

_count = COUNT('Table'[data])

Result:

Please refer to the attachment below for details. Hope this helps.

 

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.