Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |