Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
Need Help
  • Singaravelu_R's avatar
    Singaravelu_R
    5 years ago

    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's avatar
Anonymous
Not applicable
5 years ago

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?

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

With the SEARCH function that amitchandak proposed you search for "Lounge Chair" and categorize it as such. If it's "Lounge Chair" or "Lounge Chair red" or "Lounge Chair with cushion" doesn't matter.

 

The search function will then categorize all as Lounge Chair.

If you need any help please let me know.


If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi