Forum Discussion

justinleow's avatar
justinleow
Frequent Visitor
8 years ago

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's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion

    the code you posted works for me in DAX - why it doesn't work for you?