Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
My table source is from SharePoint List and the selected column - ParticipantsPickerStringId is showing in "List" by default. After extracted value, it shows the concat IDs. How to lookup the user's info from Sharepoint List- UserInformationList by using ID as key?
Solved! Go to Solution.
@XIOFEN_LIM , not very clear. You should split the list into rows to that each row have one id.
Or use split by delimiter into rows
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
@XIOFEN_LIM , not very clear. You should split the list into rows to that each row have one id.
Or use split by delimiter into rows
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Thanks @amitchandak ,
I get your point. Will try for it.
Before this i was think for a way to direct lookup info from other table based on the list in selected column.
User | Count |
---|---|
82 | |
79 | |
66 | |
49 | |
46 |
User | Count |
---|---|
103 | |
44 | |
39 | |
39 | |
39 |