The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.
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?
User | Count |
---|---|
80 | |
74 | |
41 | |
30 | |
28 |
User | Count |
---|---|
108 | |
96 | |
53 | |
48 | |
47 |