If x contains any lower case letter, then y

[Cary_Casey]

Hello,

It would be awesome for the solution to be inside power query.

I have a data set where all of column X should have capital letters. If there is a lowercase letter, then there is a user error.

My goal is to identify those that have this error among others inside a dashboard.

Example:

X	Y
NIF15181SK	0
NIF15171SK	0
NIF15182SK	0
NIf15182SK	SP Error

Highlighted the error here on the 'f' in the last row.

[ImkeF · Accepted solution]

Hi @Cary_Casey 

this is pretty easy to check in the query editor. Just add a column with this formula:

[X] = Text.Upper([X])

it compares if the content of column [X] matches its "uppercased" version 

Full code to follow along:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8vN0MzQ1tDAM9laK1YFxzVG5FkZwbhqcGwsA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [X = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"X", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Test", each [X] = Text.Upper([X]))
in
    #"Added Custom"

[Cary_Casey]

@ImkeF 

Thanks this works perfectly.

Such a simple solution. Can't believe I didn't think of that!