Forum Discussion
justinleow
8 years agoFrequent Visitor
Validating ) symbols in cells
Dear all,
would like to ask how can I validate if a cell ends with brackets.
(324) = Ok
234 = Not ok
(265) = Ok
(155) = Ok
44f = not ok
345632) = Ok
This does not work as the bracket will close the if statement.
= if(right('table'[Column1],1)=")","Ok","Not Ok")
1 Reply
- Stachu
Community Champion
the code you posted works for me in DAX - why it doesn't work for you?