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
