Forum Discussion
Multiple Values Same Column
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.
Thank you all for your help! I had to add a couple of steps at the beginning to get started, but then followed your steps (especially the screenshot) to split the columns. In the end, these were the steps:
- Right click on the original table and choose Reference. This will create a new table.
- Highlight the column(s) you want to keep and right click on it. Choose to Remove Other Columns.
- Optional depending on if there’s space between options: Click Format option and choose Trim
- Click Split column option and choose Delimiter
- At each occurrence of the delimiter
- Rows (in advanced options)
- None for Quote Character
- OK
- Click on the Filter option for that column > Remove Empty
Hi, BPelzel
Glad to see that you found a solution. Since I don't have your sample file so I can only provide you with the key steps, It’s great that these steps are useful to you.
Thank you for sharing your complete steps, could you please mark the post which help as Answered since it is working now? It means a lot to me, and it will help the others in the community find the solution easily if they face the same problem with you.Glad to help, thank you.
Best Regards,
Community Support Team _ Zeon Zheng