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]
Anonymous , Create a new column like
Switch( true(),
search("Lounge Chair",[Product],,0) >0 , "Lounge Chair",
search("Long Bench",[Product],,0) >0 , "Long Bench",
"Other"
)