cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jbotero Frequent Visitor
Frequent Visitor

Extract colors from column

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

1 ACCEPTED SOLUTION

Accepted Solutions
shebr Member
Member

Re: Extract colors from column

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

 

conditional.JPG

View solution in original post

3 REPLIES 3
PietroFarias Regular Visitor
Regular Visitor

Re: Extract colors from column

Is there any possibility in creating a column with the colors that already exists? In this way, it is easier to develop something.

shebr Member
Member

Re: Extract colors from column

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

 

conditional.JPG

View solution in original post

jbotero Frequent Visitor
Frequent Visitor

Re: Extract colors from column

Thanks!! Worked great.

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)