Forum Discussion

rezaaditia's avatar
rezaaditia
Helper III
7 years ago
Solved

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] = "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

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    7 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
  • Anonymous's avatar
    Anonymous
    7 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])
	)
)

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 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
    • rezaaditia's avatar
      rezaaditia
      Helper III
      7 years ago

      thanks Anonymous  its working now.

       

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

       

      thanks

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 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])
	)
)