Match Comma Separated Users value in Column

[Anonymous]

Hello,

I'm trying to Identify what groups a user is a member of.  Currently I have exported from AD all group details into CSV and then loaded into Power BI.  The table consists of 4 Columns, Name, Category, Scope and Members.  Members contains the comma seperated samAccountNames of all members of the group.

The end goal is to be able to slice by User, Manager, or Dept, to identify common groups.  What would be the best way to accomplish this?

I appreciate any assitance provided.

[jthomson · Accepted solution]

I'd use Power Query to clean the data - split the members column at each instance of the delimiter, then pick the other three columns and unpivot the rest

[Anonymous]

This did exactly what I was looking for.  Thanks for the answer.