User Profile
pbin9_9
Regular Visitor
Joined 3 years ago
User Widgets
Contributions
PBI Column Based Unstructured Data Grouping
Hi All, I have a dataset as below, Data Group1 Jeremiah Lee Joshua Doyle Group2 Julie Miller Beth Stein Group3 Sierra Carroll Zachary Williams Group1 Paul Wilson Group2 Abigail Nelson Group3 Raymond Dillon Mark Rodriguez Group1 Glenn Collins Robin Horne Group2 Angelica White Robert Ryan Robert Wright Raven Davis Tara Meyers Group3 Cynthia Smith John Sanchez Lori Gilbert The column name is Data Basically I want to group names for each Groups The expected output is something like that for a few example, Group1 Jeremiah Lee Group1 Joshua Doyle Group1 Paul Wilson Group2 Julie Miller Group2 Beth Stein Group2 Abigail Nelson Group3 Sierra Carroll Group3 Zachary Williams Group3 Raymond Dillon Group3 Mark Rodriguez Power Query or DAX solutions would be fine, actually I have no idea how can I make this grouping. Is there anyone have idea on it ?Solved771Views0likes2Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.