Forum Discussion
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, ...
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,
Hi anupampandey
Here is a link to the sample data: https://1drv.ms/x/s!ArM9L8ohYGT4gQhszs0ssIc8haUT
Thank you :)
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,
Thank you v-sihou-msft :)