Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to extract records value into a cell

Hello All, I have a SharePoint list that has two fields. 1-Project name (Single line of text) 2-Managers (Person or Group> Allow multiple selection>Yes) I imported this into Power BI. At power Q...
Need Help
  • ImkeF's avatar
    ImkeF
    5 years ago

    Hi Anonymous ,

    instead of expanding the column, you can add a new column with this formula:

     

    Text.Combine([Managers][title], ", ")

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous I can never remember that one. edhans ImkeF 

  • ImkeF's avatar
    ImkeF
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Hi Anonymous ,

    instead of expanding the column, you can add a new column with this formula:

     

    Text.Combine([Managers][title], ", ")