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" ...
Omid_Motamedise
1 year agoSuper User
you can use this formula instead
=each List.Contains({"2022","2023","2024","2025","2026"}, _ )