IF And function more than 2 conditions

[rezaaditia]

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] = "yes"
    AND [Validate Source] = "backlog"
    AND [Validate Po Approval] = "no"
    AND [poa] !=""
    THEN "True"
    ELSE "false"
END

can someone please help me how to achieve this?

Thanks

[Anonymous · Accepted solution]

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

[Anonymous · Accepted solution]

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

[rezaaditia]

thanks @Anonymous  its working now.

next question, if i want to create in measure, can you please teach me again 🙂

thanks

[Anonymous · Accepted solution]

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])
	)
)