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