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

PowerBI Syntax return value where match

Hi, 

 

I am trying to return value where match the tag; for example:

 

Column [Tags]: 

{ "Application": "ebs", "CommonService": "N", "Environment": "Staging", "Owner": "PLI-GROUP-ECP", "Role": "Web", "Service": "O365 - SP"}

 

if word match ebs will return value as ebs in new column. 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: PowerBI Syntax return value where match

Try that one:

 

CUSTOM COLUMN = IF(SEARCH("ebs";Table1[Column Name];;0);"ebs"
 

 

2 REPLIES 2
Highlighted

Re: PowerBI Syntax return value where match

Try that one:

 

CUSTOM COLUMN = IF(SEARCH("ebs";Table1[Column Name];;0);"ebs"
 

 

Community Support Team
Community Support Team

Re: PowerBI Syntax return value where match

Hi @terrencehew ,

 

Does christianfcbmx's suggestion meet your requirement? If yes, please kindly accept it as a solution so that it can benefit more users. If not, please illustrate your scenario with detailed data and desired output. How to Get Your Question Answered Quickly

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.