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
Thank you for helping me learn power BI query , this is also super helpful
Thank you, glad know this.
If this resolves your issue, you can please mark it as a solution.