Forum Discussion

PowerBI-Curious's avatar
PowerBI-Curious
Helper I
9 years ago
Solved

IF Function 2 conditions

Hi 

 

I am trying to get an IF dax to work, I have the one I used in excel but can't seem to get it to work in power BI. This is my excel reference: 

 

=IF([Non-Compliant]>0, IF(OR([Comments]=0, [Evidence Files]="Without Evidence"), "No", "Yes"), "Needs evidence and/or comments")

 

Essentially what I want to happen is if the non-compliant is >0 the following occurs: 

No comments or Evidence (seperate columns)= Needs Evidence and or comments

Has Comments = Yes

Has Evidence (says "without evidence" when no evidence) = Yes

 

Thanks :) 

 

Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    PowerBI-Curious

     

    As I tested, your expression works properly. You may verify your logic to get your expected result.

     

    Column = IF('sample'[Non-Compliant]>0,IF('sample'[Comments]="0" || 'sample'[Evidence Files]="Without Evidence","No","Yes"),"Need comments and or Evidence")

     

     

    Regards,

4 Replies