Forum Discussion
rezaaditia
7 years agoHelper III
IF And function more than 2 conditions
Hi - I am trying do if and function with more than 2 condition in DAX which there is limitation on that. IF DATE([sap_insert_date]) = [Filter Date Validate]
AND [Validate Po Release Supplier...
- Anonymous7 years ago
You can use && instead of AND, so your code would look something like this.
For further reading, here is a link to the DAX operator reference: https://docs.microsoft.com/en-us/dax/dax-operator-reference
Hope this helps.
IF DATE([sap_insert_date]) = [Filter Date Validate] && [Validate Po Release Supplier] = "yes" && [Validate Source] = "backlog" && [Validate Po Approval] = "no" && [poa] !="" THEN "True" ELSE "false" END - Anonymous7 years ago
You can start with something like this:
CALCULATE ( [Your Measure] ,FILTER ( 'Table' ,'Table'[sap_insert_date] = MAX([Filter Date Validate]) && 'Table'[Validate Po Release Supplier] = "yes" && 'Table'[Validate Source] = "backlog" && 'Table'[Validate Po Approval] = "no" && NOT ISBLANK('Table'[poa]) ) )
Anonymous
7 years agoNot applicable
You can use && instead of AND, so your code would look something like this.
For further reading, here is a link to the DAX operator reference: https://docs.microsoft.com/en-us/dax/dax-operator-reference
Hope this helps.
IF DATE([sap_insert_date]) = [Filter Date Validate]
&& [Validate Po Release Supplier] = "yes"
&& [Validate Source] = "backlog"
&& [Validate Po Approval] = "no"
&& [poa] !=""
THEN "True"
ELSE "false"
END- rezaaditia7 years agoHelper III
thanks Anonymous its working now.
next question, if i want to create in measure, can you please teach me again :)
thanks
- Anonymous7 years agoNot applicable
You can start with something like this:
CALCULATE ( [Your Measure] ,FILTER ( 'Table' ,'Table'[sap_insert_date] = MAX([Filter Date Validate]) && 'Table'[Validate Po Release Supplier] = "yes" && 'Table'[Validate Source] = "backlog" && 'Table'[Validate Po Approval] = "no" && NOT ISBLANK('Table'[poa]) ) )