Forum Discussion

MortenK's avatar
MortenK
Regular Visitor
4 years ago
Solved

Converting List to Group

Hi,   I have made a query towards Airtable, and my data came sorted in Lists. I have not been able to convert this data to Groups such that I am able to organise charts on the basis of the data beh...
Need Help
  • MortenK's avatar
    MortenK
    4 years ago

    Thanks Pete,

     

    I ended doing a walk around and using Table.AddColumns, which leaves me with the first datapoint and access to using the data in the graphics. The first element is the most cruical either way so this was fine. Thank you for the support. 

     

    = Table.AddColumn(#"Renamed Columns1", "Industrials.1", each if Value.Is([#"Industrials Rollup (from Industrials)"],type list) then [#"Industrials Rollup (from Industrials)"]{0}

    else "")

     

    Morten

MortenK's avatar
MortenK
Regular Visitor
4 years ago

Thanks so much Pete. Just a practical question, but given the fact that I have 136 different industry categories, which again can be translated into 14 various sector, would the formula above be the most efficient work around?

 

I would assume I would need to code for all the various industries AND all the various combinations (fashion, manufacturing).