Forum Discussion

Bbrown44's avatar
Bbrown44
Icon for Advocate II rankAdvocate II
7 years ago
Solved

create a custom column with multiple or condition statement DAX

I am trying create a custom column with the follow DAX systax which is now working create a column with select if statement with multiple AND statements: Compliant Variable = IF([sesis_valid_subject] ...
Tutorial Requests
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    Hi Bbrown44,

    Could you have tried with AND function?

    See below picture and code, it could filter the right row:

    Column 2 = IF(AND('Table1'[Value]=2,AND(Table1[Running total]=37,AND([Column]=37,[Date]<>BLANK()))),"True")

     

    Regards,

    Daniel He

     

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi Bbrown44,

Could you have tried with AND function?

See below picture and code, it could filter the right row:

Column 2 = IF(AND('Table1'[Value]=2,AND(Table1[Running total]=37,AND([Column]=37,[Date]<>BLANK()))),"True")

 

Regards,

Daniel He