PowerBI Syntax return value where match

Question

Hi,&nbsp;&nbsp;I am trying to return value where match the tag; for example:&nbsp;Column [Tags]:&nbsp;{ "Application": "ebs", "CommonService": "N", "Environment": "Staging", "Owner": "PLI-GROUP-ECP", "Role": "Web", "Service": "O365 - SP"}&nbsp;if word match ebs will return value as ebs in new column.&nbsp;

christianfcbmx · Accepted Answer

Try that one:&nbsp;CUSTOM COLUMN = IF(SEARCH("ebs";Table1[Column Name];;0);"ebs"&nbsp;&nbsp;

Forum Discussion

PowerBI Syntax return value where match

2 Replies

Related content

Syntax problem

SQL Query Syntax issue

The syntax for 'RETURN' is incorrect

IF and RETURN syntax error

SQL syntax error