Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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"
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |