Forum Discussion
ritanoori
Resolver I
Resolver ICustom column - if first 9 characters column is alphanumeric or numeric
Hello Everyone I'm trying to create a custom column in power querey where if the first 9 characters of [description] is alphanumeric then "Y" else if the first 9 characters of [description] is nume...
ritanoori , Try something like
if Value.Is(Text.Start([description],9) Int64.Type) then "Y" else if Value.Is(Text.Start([description],9) Text) then "X" else "N/A"
ritanooriResolver I
Resolver IThanks. But I need this in power querey.
amitchandak
Super User
Super Userritanoori , Try something like
if Value.Is(Text.Start([description],9) Int64.Type) then "Y" else if Value.Is(Text.Start([description],9) Text) then "X" else "N/A"