Forum Discussion
Custom column groupings
Hi, I've got a column called "Products" that contains all sorts of products - for instance: Lounge Chair Lounge Chair Cushion, Red Lounge Chair Cushion, Blue Long Bench 160 Long Bench 160 Cu...
Hi Anonymous
In the query editor duplicate the column Product and by using split column by space
close and save the query editor then in the data section create calcuate column
Master Product = 'Table'[Product - Copy.1] &" "& 'Table'[Product - Copy.2]
selimovd amitchandak Singaravelu_R
Thank you for your replies.
Is it also this solution that I should use, even though i've got about 500-1000 products and probably have to create about 200 master products?
Or is there some way where I can just "remove" cushion (and potentially color) from the equation?
Hi Anonymous
In the query editor duplicate the column Product and by using split column by space
close and save the query editor then in the data section create calcuate column
Master Product = 'Table'[Product - Copy.1] &" "& 'Table'[Product - Copy.2]