Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone.
I have a table with several columns, one of them is the description of the product, which, among other things, has a color in the text. For example: Short sleeve shirt for men blue size M.
I want to know if I can specify a conditional to extract only colors onto another column with DAX or Query Editor.
The color is not always on the same position, so trimming words is not an option.
Thanks for your kind help.
Best regards,
Juan
Solved! Go to Solution.
Hi @jbotero
If you go into your Power BI editor, add a conditional column there is an operator that allows you to specify 'contains'. You could use this to pick out the colours and set the value in a new column. See image.
Let me know how you get on.
Thanks
shebr
Hi @jbotero
If you go into your Power BI editor, add a conditional column there is an operator that allows you to specify 'contains'. You could use this to pick out the colours and set the value in a new column. See image.
Let me know how you get on.
Thanks
shebr
Thanks!! Worked great.
Is there any possibility in creating a column with the colors that already exists? In this way, it is easier to develop something.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |