Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Match Comma Separated Users value in Column

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, Nam...
Need Help
  • jthomson's avatar
    jthomson
    5 years ago

    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

jthomson's avatar
jthomson
Solution Sage
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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