Forum Discussion
Search for exact string in column
I want to search for exact string in a column and then get a particular value.
Formula i use:
asb Rev new = if(CONTAINSSTRING([segment],"asb"),[asb Rev],blank())
But There are values in segment like asb, asb TSS, asb NIV.
Hi Anonymous ,
As tested, Greg_Deckler 's solution can help you.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- Greg_Deckler
Community Champion
Anonymous Maybe:
asb Rev new = if(FIND([segment],"asb",,0)>0 && LEN([segment])=3),[asb Rev],blank())Probably a better way, I'll look. In the mean time, if you could post sample data I could mock this up. Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2. - Greg_Deckler
Anonymous - Oh, yeah, here is another way:
asb Rev new = if([segment]="asb"),[asb Rev],blank())- amitchandak
Super User
Anonymous , I think it should solve with the solution by Greg_Deckler already provided.
if not you need to provide data.
v-lionel-msftCommunity Support
Hi Anonymous ,
As tested, Greg_Deckler 's solution can help you.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
