Power BI DAX Multiple Conditions in a single IF statement[URGENT}
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 trying to customize a column called TSIP Hours where the output is basically Append Sales Invoices[Quantity] that goes through an IF condition.
When the Append Sales Invoices[Amount] is 0 and Append Sales Invoices[Header.No] is either "20144" or "20140" then Output is the Append Sales Invoices[Quantity]. I put the formula down below. The problem is, it's populating the quantity regardless of the If condition - so if the quantity is 1 or greater, it still populates where it should only populate when Amount is 0.
Hi @PoojaShri , I have one last question if you can help. So basically similar concept, except Amount has to be >0 and Append Sales Invoices'[Header.No_] IS NOT/Not Equal To 20140, 20141, 20142, 20143. This is what I put but it's not correct: