Forum Discussion

damonkimble's avatar
damonkimble
Frequent Visitor
5 years ago
Solved

DAX IF condition help

Hi, I have three variables called: Append Sales Invoices[Amount] = Type Decimal Number Append Sales Invoices[Header.No] = Type Text Append Sales Invoices[Quantity] Type Decimal Number   I am tr...
Need Help
Tips and Tricks
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, damonkimble 

    You need to use parentheses  ( ) to encapsulate the second condition.

     

    TSIP Hours = IF('Append Sales Invoices'[Amount] = 0 && ('Append Sales Invoices'[Header.No] = "20144" || "20140"), 'Append Sales Invoices'[Quantity])

     

     
    Best Regards,
    Community Support Team _ Eason


v-easonf-msft's avatar
v-easonf-msft
Community Support
5 years ago

Hi, damonkimble 

You need to use parentheses  ( ) to encapsulate the second condition.

 

TSIP Hours = IF('Append Sales Invoices'[Amount] = 0 && ('Append Sales Invoices'[Header.No] = "20144" || "20140"), 'Append Sales Invoices'[Quantity])

 

 
Best Regards,
Community Support Team _ Eason