Forum Discussion
relation comma seperated fields
Hello All, I'm quiet new to PowerBi and looking for some guidance on the following case: I have 2 textfiles: Groups: GroupID,GroupDisplayName 554dc39f-a4a2-422d-b298-c3eb1fdb66fe,GroupN...
HotChilli
Community Champion
Community ChampionIn power query, if you split the column CaUserGroupsInclude(split column by delimiter, on ',' using split to rows)
the relationship will work.
You might have to Clean or Trim the column if there are extra spaces.
Tnx for your reply!
The result is this:
Would it be possible to have the groupnames in the same field per policy?
Like this:
| Ca Policy | GroupIDs | GroupDisplayNames |
| CA Policy 1 | 554dc39f-a4a2-422d-b298-c3eb1fdb66fe,36c718d4-3ee5-42c6-a524-6c5461d61e93 | GroupName4 GroupName1 |
| CA Policy 2 | 4d502719-f081-47c7-a263-b51a9699408e,1f452b67-77b9-43cc-aa52-82fb931b4546,36c718d4-3ee5-42c6-a524-6c5461d61e93 | GroupName3 GroupName2 |
| CA Policy 3 | 554dc39f-a4a2-422d-b298-c3eb1fdb66fe | GroupName1 |