DAX question for create a new column

[Anonymous]

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!

[jherralo95]

Try with:

Confirm = IF(AND(Customer[ProductId]="1102";YEAR(Customer[Date])=2017;OR(Customer[Version]="Ver 1";Customer[Version]="Ver 3"));"Yes";"")

[Anonymous]

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

[Anonymous · Accepted 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", "")

[Anonymous]

Thank you !