Forum Discussion
Helper IICounting a column after splitting by delimiters
I have a column with some (but not all) values that are split by commas, and I want to split them by delimiter. My goal is to put these in a chart where they are recognized as distinct values. For example, the value "hand, finger" would be broken into two separate values when I split them by delimiter. However, I need help figuring out how to count them as distinct values without "duplicating" the rest of my data. I only want the values in this one column to be counted as many times as needed, but I don't want the rest of my data to be duplicated once this one column is split by delimiter. Thanks in advance!
Hi ld17 ,
Would you please give us a picture of expected outcome? You can just dummy it up in Excel. and tell us what you would want the count to be.
If you would share your pbix, or dummy up some values in Excel both for current and expected data. Please copy and paste them into your post, rather than doing a picture, we may be able to help you.
Please read this post to get your question answered more quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Nathaniel
3 Replies
- Nathaniel_C
Community Champion
Hi ld17 ,
Would you please give us a picture of expected outcome? You can just dummy it up in Excel. and tell us what you would want the count to be.
If you would share your pbix, or dummy up some values in Excel both for current and expected data. Please copy and paste them into your post, rather than doing a picture, we may be able to help you.
Please read this post to get your question answered more quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Nathaniel Hi ld17 ,
Sorry for that the information you have provided is not making the problem clear to me.
Please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.Refer to:
How to Get Your Question Answered Quickly - Microsoft Power BI Community
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Eyelyn Qin- ld17
Thanks, all. The solution ended up being to create another table, import my data again, delete all columns except the one I needed, and then create a relationship between the new table and the original table.
