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).

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi MortenK ,

 

If you want to be able to control by both Sector and Industry then, assuming that Industry is a subset/subcategory of Sector, I would just change these references to point to your [Industry] list column instead:

 

I'd then create a Sector dimension table that correlates the Sector to Industry groups, and relate this to your fact table on dimension[Sector] ONE : MANY fact[Sector].

 

Pete