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]
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hello Anonymous ,

 

yes that's possible.

You can either group them with new calculated column. Then you can check if Product contains "Lounge Chair" then it should be "Lounge Chair". Check the SWITCH/TRUE combination for that case:

DAX - The Diabolical Genius of “SWITCH TRUE” | P3 (powerpivotpro.com)

 

Or you can click with the mouse button to the column "Product" and chose "New group". There you can group easier by just combining the results to specific groups together:

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