Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
below is my coloumn
and calculated coloumn
Solved! Go to Solution.
status =
IF(
SEARCH("NoNoNo",'Ch2 GCSPs'[Region&SLnow&oldSL&exception&TBC&Duplicate],1,0)>0 &&
SEARCH("CBS",'Ch2 GCSPs'[Region&SLnow&oldSL&exception&TBC&Duplicate],1,0)>0,
"In Markets, Other SMU"
)
@vjnvinod , Search is not case sensitive, so should work
refer if power query can help
https://www.youtube.com/watch?v=YxZ_8-vsEpE
refer fuzzy matching can help :https://www.poweredsolutions.co/2019/03/26/fuzzy-matching-in-power-bi-power-query/
status =
IF(
SEARCH("NoNoNo",'Ch2 GCSPs'[Region&SLnow&oldSL&exception&TBC&Duplicate],1,0)>0 &&
SEARCH("CBS",'Ch2 GCSPs'[Region&SLnow&oldSL&exception&TBC&Duplicate],1,0)>0,
"In Markets, Other SMU"
)
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |