Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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]) ) )
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
thanks @Anonymous its working now.
next question, if i want to create in measure, can you please teach me again 🙂
thanks
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]) ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |