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"
     

     

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

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