custom column search

Question

Can you help me with measure or custom column. Not sure which is easier.tableaid&nbsp; &nbsp;name&nbsp; &nbsp;order date&nbsp; &nbsp; ship date&nbsp; &nbsp;order_desc&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;custom_desc&nbsp;1&nbsp; &nbsp; &nbsp;john&nbsp; &nbsp; &nbsp; &nbsp;7/1/2023&nbsp; &nbsp; 7/3/2023&nbsp; &nbsp; &nbsp; bike, boat&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp;mary&nbsp; &nbsp; &nbsp; &nbsp;7/2/2023&nbsp; &nbsp; 7/2/2023&nbsp; &nbsp; &nbsp; boat&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; tim&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7/4/2023&nbsp; &nbsp; 7/5/2023&nbsp; &nbsp; &nbsp;bike4&nbsp; &nbsp; &nbsp; &nbsp;sarah&nbsp; &nbsp; &nbsp; 7/6/2023 7/7/2023&nbsp; &nbsp; &nbsp; &nbsp; car, boat&nbsp;Not sure which is better. output custom column or&nbsp; Measurei want to search order_desc for bike and not boatI will want to see all bike and also all boatscustom_descbikeboat&nbsp;&nbsp;

parry2k · Answer

Anonymous&nbsp;what do you want in the custom_desc column?
&nbsp;
👉 Learn Power BI&nbsp;and Fabric - subscribe to our YT channel - @PowerBIHowTo

anonymous · Answer

&nbsp;something likeif&nbsp;order_desc contains&nbsp; bike and not boat then 'bike only'else bike&nbsp;&nbsp;

anonymous · Answer

I want to search and pull both but separate them

parry2k · Answer

Anonymous&nbsp;you have to be clear in your requirement, what when there is a car and boat (last record in your example)?&nbsp;
&nbsp;
People here are helping here each other and spending their time, the more clear you are in your requirement, the better it is.

anonymous · Answer

&nbsp;when there is a car and boat i want boat

Forum Discussion

custom column search

7 Replies

Related content

Custom Column

Slicer Search Bar

search unused columns

Custom Column

Searching the value and updating it in new columns.