Forum Discussion
DAX multiple condition in a single IF condition
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 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, damonkimble
According to this error message, you can change the DAX formula like this and check if it can work:
TSIP Hours = if('Append Sales Invoices'[Amount] = 0 && 'Append Sales Invoices'[Header.No_] in {"20144","20140"}, 'Append Sales Invoices'[Quantity],BLANK())If this DAX can work, would you like to mark my reply as a solution?
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
damonkimble Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Hi, damonkimble
According to your DAX formula, I think the second condition in your IF() function is incorrect, you can change the DAX formula like this:
TSIP Hours = if('Append Sales Invoices'[Amount] = 0 && ('Append Sales Invoices'[Header.No_] in {"20144","20140"}, 'Append Sales Invoices'[Quantity])And you can get what you want.
If you still have a problem, you can post some sample data(without sensitive data) and your expected result.
How to Get Your Question Answered Quickly
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, thank you for the response. Unfortunately, I get an error message "Operator or expression '()' is not supported in this context. I'll attach a screenshot of the data provided.
Hi, damonkimble
According to this error message, you can change the DAX formula like this and check if it can work:
TSIP Hours = if('Append Sales Invoices'[Amount] = 0 && 'Append Sales Invoices'[Header.No_] in {"20144","20140"}, 'Append Sales Invoices'[Quantity],BLANK())If this DAX can work, would you like to mark my reply as a solution?
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
