PowerBI Syntax return value where match

[Anonymous]

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. 

[v-yulgu-msft]

Hi @Anonymous ,

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

[christianfcbmx · Accepted solution]

Try that one:

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