Forum Discussion

Harris0211's avatar
Harris0211
New Member
2 years ago
Solved

Different column format

Hi all,   I am very new to the Power BI world and would like someone to help me with my query. I imported a SharePoint document library into PowerBi, which was very straightforward. However, a few...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi Harris0211,

     

    On the top right of the column, there is an expand icon which you can use  to either combine the elements of a list into a single text or expand  the elements into rows. If you want to access just the first element, create a custom column and enter this formula:

    [Company Name]{0}

     That said, the second element is {1} as index in M starts with 0.

danextian's avatar
danextian
Super User
2 years ago

Hi Harris0211,

 

On the top right of the column, there is an expand icon which you can use  to either combine the elements of a list into a single text or expand  the elements into rows. If you want to access just the first element, create a custom column and enter this formula:

[Company Name]{0}

 That said, the second element is {1} as index in M starts with 0.