Results 1 to 10 of 10

Excel Power Query Grouping list

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-03-2021
    Location
    London
    MS-Off Ver
    365
    Posts
    804

    Excel Power Query Grouping list

    Hi,

    I'm trying to group an extracted list, my starting point is ;
    = Table.Group(Source, {"Product"}, {{"Count", each List.Sum([Sales]), type number},
    {"St Dev" , each List.StandardDeviation([Sales] ) } , 
     {"Alll", each _, type table }, 
    { "Who sold what" , each Text.Combine( List.Distinct( [SalesRep]),", " )  }} )
    which I am then re grouping so I can rank them, I've attached a work book with three queries, one is what I want but it has a lot of steps which I've been trying to reduce, the problem is the 'who sold what ' column which I can't access, you will see what I've been trying in query two, all I can think is it's because there are more than one value but i can't figure a way round it.

    Richard.

    FURTHER CLARIFICATION IN POST#6
    Attached Files Attached Files
    Last edited by AliGW; 08-14-2022 at 10:20 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 11-12-2021, 03:44 AM
  2. Power query grouping - conditional to data across several columns??...
    By sunnyspirit in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-01-2021, 11:53 AM
  3. Data grouping in Power Query
    By hudson andrew in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2020, 10:44 AM
  4. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  5. [SOLVED] Get and Transform (Power Query) - Grouping numbers into bands/buckets
    By TheNewUnion in forum Excel General
    Replies: 2
    Last Post: 03-12-2019, 05:37 AM
  6. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  7. Help with grouping in power query
    By stephme55 in forum Excel General
    Replies: 1
    Last Post: 07-26-2016, 03:09 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1