Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Data Quality rules

Hello all   I am building Data Quality dashboard based on Excel datasets. I have a column and I need to apply these two rules on it and check which row entry satisfy these rules and which doesn't. ...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    DAX function CONTAINSSTRING() can help.

    https://docs.microsoft.com/en-us/dax/containsstring-function-dax

    See the following example.

    Column = 
IF (
    CONTAINSSTRING ( 'Table'[Column1], " " ) = TRUE ()
        && CONTAINSSTRING ( 'Table'[Column1], "!" ) = FALSE ()
        && CONTAINSSTRING ( 'Table'[Column1], "@" ) = FALSE ()
        && CONTAINSSTRING ( 'Table'[Column1], "#" ) = FALSE (),
    1,
    0
)

     

    Best Regards,

    Jay

     

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.