Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
i want to create from these two columns only one in this format.
id, CategoryName
c7a..., Importing, NewOne
It is possible to make this transformation in QueryEditor? Nearly a split column-transformation backward. Thank you for your feedback.
Solved! Go to Solution.
I can not share sample data because i get an error.
I have one table with dublicated rows. Dublicated becuase one id have different categories. And the goal is to combine the dublicated rows in one with the format you see in my first post. I hope this is understandable.
The challenge is like this:
https://stackoverflow.com/questions/61238999/how-to-combine-rows-with-the-same-id-into-a-list
I want to combine this two columns like this:
ID, Category
1, Green | Blue
It looks like the hint in this link works. I had a mistype in my codings earlier.
This is the solution. Anyway, thank you for your help.
@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.
I can not share sample data because i get an error.
I have one table with dublicated rows. Dublicated becuase one id have different categories. And the goal is to combine the dublicated rows in one with the format you see in my first post. I hope this is understandable.
The challenge is like this:
https://stackoverflow.com/questions/61238999/how-to-combine-rows-with-the-same-id-into-a-list
I want to combine this two columns like this:
ID, Category
1, Green | Blue
It looks like the hint in this link works. I had a mistype in my codings earlier.
This is the solution. Anyway, thank you for your help.
The logic is that I have n-IDs and one ID can have n Categories (1-n)...
I have dublicate rows and want to combine these rows where the ID have more than one Category
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
79 | |
67 | |
60 | |
45 | |
45 |