Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Try that one:
CUSTOM COLUMN = IF(SEARCH("ebs";Table1[Column Name];;0);"ebs"
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
Try that one:
CUSTOM COLUMN = IF(SEARCH("ebs";Table1[Column Name];;0);"ebs"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |