Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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": "...
Need Help
  • christianfcbmx's avatar
    christianfcbmx
    7 years ago

    Try that one:

     

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

     

christianfcbmx's avatar
christianfcbmx
Post Patron
7 years ago

Try that one:

 

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