Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am try to create a new category column based on another column in my data model. Below is an example of what I am try to accomplish. Please let me know.
Column Data: Shirts, Sweaters, Jeans, Shorts --> New Category: Clothes
Column Data: Sneakers, Boots, Sandals, Slippers --> New Category: Shoes
Thanks,
Tony
Solved! Go to Solution.
Hi @TDERUSSO
Here is a quick and easy approach in DAX. Just add a calculated column to your table (replace Table2[Column1] with your details.
Category Column = SWITCH( TRUE(), Table2[Column1] In {"Shirts","Sweaters","Jeans","Shorts"},"Clothes", Table2[Column1] In {"Sneakers","Boots","Sandals","Slippers"},"Shoes", "Other" )
Hi @TDERUSSO
Here is a quick and easy approach in DAX. Just add a calculated column to your table (replace Table2[Column1] with your details.
Category Column = SWITCH( TRUE(), Table2[Column1] In {"Shirts","Sweaters","Jeans","Shorts"},"Clothes", Table2[Column1] In {"Sneakers","Boots","Sandals","Slippers"},"Shoes", "Other" )
That worked, thanks for your help!
Thanks, I will give this a try!
Another option is to create a Group.
From the Fields menu, click the elipsis next to the column you'd like to create groups for and click the "New Group" option at the bottom to bring up a window where you can build custom groups.
Hey @TDERUSSO
Have you thought about creating a sperate table that had the categories and then connecting them with a 1:many relationship?
Hi goaltender36, No, I'm new to Power BI. Is that the best approach to handle this?