IF Function 2 conditions

[PowerBI-Curious]

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 🙂 

[PowerBI-Curious]

Hi @anupampandey

Here is a link to the sample data: https://1drv.ms/x/s!ArM9L8ohYGT4gQhszs0ssIc8haUT

Thank you 🙂

[v-sihou-msft · Accepted solution]

@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,

[PowerBI-Curious]

Thank you @v-sihou-msft 🙂

[anupampandey]

@PowerBI-Curious,

Will you please share some sample data?

Thanks,

Anupam