Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
Hi ddpl, my apologies, that actually worked perfectly. Many thnaks for pointing that out. Appreciate it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |