Forum Discussion
Solved
Pass multiple argument in IF statement
Hi how to pass multiple argument in if statement. I want a statement like this IF(apple,banana,cucumber) ,1 ,0). If the row has value apple, banana or cucumber it should show 1 or else it should show 0. Thanks
Try like : if([item] in {"apple","banana","cucumber"},1,0)
2 Replies
Try like : if([item] in {"apple","banana","cucumber"},1,0)
Need to understand data. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Can't tell if this should be:
IF([column]="apple" || [column]="banana" || [column]="cucumber")
or something else.
