Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have a requirement to convert below Qlik script to Power bi
// ID
if(WildMatch(Column,'*ABC*'),'N',
)
For example, I am trying to hot code a middle text that starts with any text and ends with any text using the wild card option in Power Bi Desktop.
Solved! Go to Solution.
hi check this measure if works with you :
ID = IF(
SEARCH("ABC", [Column], 1, 0) > 0,
"N",
BLANK()
)
Please accept as a solution if it works with you .
Regards ,
hi check this measure if works with you :
ID = IF(
SEARCH("ABC", [Column], 1, 0) > 0,
"N",
BLANK()
)
Please accept as a solution if it works with you .
Regards ,
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |