Forum Discussion
Anonymous
1 year agoNot applicable
List.Transform Error when using List.Contains or List.ContainsAny but not when using OR comparison.
Hello, I am working on some transformation, and I have found out behavior of PQ that I dont understand. When I am using the code: = List.Transform( Custom3{0}[Record], each if _ = "2024" ...
lbendlin
1 year agoSuper User
The .. notation only works with integers or with single characters. For example {"A".."Z"} works but {"AA".."ZZ"} doesn't.
Create a numeric list {2020..2030} and then use Text.From(_)
= List.Generate(()=> 2020, each _ < 2031 , each _ +1, each Text.From(_))
or
= List.Transform({2020..2030},each Text.From(_))