Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
DRJ1994
Helper I
Helper I

Help with Delimiting

Hi guys,

 

Hopefully someone can help with my query, although I am not sure if what I am trying to do is possible or not.

 

I have a table with the column pictured below. 

DRJ1994_0-1689602855594.png

I am trying to delimit by ";" (The / is fine and I do not need to delimit by this). So if we take the top row for example it should be split into rows as follows:

Attendance allowance / state pension / pension credit
Benefits advice

Physical health

Visit

Well being

 

The issue I am having is PBI is counting these now as 5 seperate entries rather than 1. For example the source data there are only 4600 entries, but when I delimit in PBI and performing a count there are over 12000 entries. So I think the issue is that it is counting each row as it's own entry, I understand why this is happening but I am just trying to see if there is a way to bring it closer to the 4600 that is on the source data.

 

Is there a way to fix this? I have tried a few different things but have had no joy. 

 

Thanks in advance.

 

DRJ.

1 REPLY 1
HotChilli
Super User
Super User

What are you trying to fix? 

--

Are you trying to find a way to keep the related rows 'together'?  If so, are there any other columns in the table which act as a key?

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.