Forum Discussion
Solved
Conditional formatting for power query
I am trying to write a conditional column as below: if([Final Bucket Ids]<>[Initial Bucket Id] && List.ContainsAny([Final Bucket Ids],'440','441','442','443'),1,0) My goal is if the value in Fi...
if [Final Bucket Ids]<>[Initial Bucket Id] and List.ContainsAny([Final Bucket Ids], {"440","441","442","443"}) then 1 else 0
Try:
if Text.Lower([Final Bucket Ids]) <> Text.Lower([Initial Bucket Id]) and
List.Contains({440, 441, 442, 443}, [Final Bucket Ids])
then 1
else 0
Note: Power Query is case-sensitive, so it's always a good idea to validate the data before applying transformations.