Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I want create a column for my customer table, but my DAX did not work very well.
So I want my column can satisfy 3 condtions, ProductID is 1102, and Date belong to 2017, Also the version could be Ver 1 or Ver 3, then in my new column could be marked as Yes, but in my result, it missed one(Redline marked)
I want to know the correct DAX to satisfy my condition.
Thank you!
Solved! Go to Solution.
Hi @Anonymous
Below is an example of what you are trying to achieve
Confirm = IF(AND('Table'[ProductID] = 1102, AND('Table'[Date].[Year] = 2017, OR('Table'[Version] = "Ver 1", 'Table'[Version] = "Ver 2"))), "Yes", "")
Try with:
Confirm = IF(AND(Customer[ProductId]="1102";YEAR(Customer[Date])=2017;OR(Customer[Version]="Ver 1";Customer[Version]="Ver 3"));"Yes";"")
Hi @Anonymous
As you have 3 conditions, you will need to use nested AND statements e.g. if(AND(condition 1, AND(condition 2, OR(Condition3, condition 4)))
Try that and let me know if it works. Alternatively if you could share the PBI file, it would be helpfull
Hi @Anonymous
Below is an example of what you are trying to achieve
Confirm = IF(AND('Table'[ProductID] = 1102, AND('Table'[Date].[Year] = 2017, OR('Table'[Version] = "Ver 1", 'Table'[Version] = "Ver 2"))), "Yes", "")
Thank you !
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |