Grouping Columns.

[1001]

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.    

[ddpl · Accepted solution]

@1001 

[1001]

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]

@1001 , 

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

[1001]

Hi ddpl, my apologies, that actually worked perfectly. Many thnaks for pointing that out. Appreciate it.