Forum Discussion
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...
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
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
This did exactly what I was looking for. Thanks for the answer.