Forum Discussion

1001's avatar
1001
Resolver II
3 years ago
Solved

Grouping Columns.

Hi, When grouping data in the Query Editor, is it somehow possible to keep other columns in addition to the two default columns?  For example: I'm grouping a unique ID column and summing the sales column. But, I wish to also keep the date, shop location, product ID and Product dscripriptions columns also, but PBI discards these these and only give me two - the Unique ID and Sales. How would I get around this to also display the other columns?  Thx.    

4 Replies

    • 1001's avatar
      1001
      Resolver II

      Sorry, My meaning is I don't wish to group other columns but merely 'display' (keep) them. Is this possible?

      I'm thinking not.   Thx.

      • ddpl's avatar
        ddpl
        Solution Sage

        1001 , 

         

        Can you share sample dataset and expected result...?