Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

DAX for checking if ID is same

I have two tables: FactAppointment and FactSales. These tables have true/false columns FactAppointment[NewPatient] and FactSales[FirstSale]. Both tables also contain the column "UserID".

I want a calculated column in FactSales which states:
IF FactAppointment[NewPatient] = TRUE AND FactSales[FirstSale] = TRUE AND UserID is the same, then TRUE, else FALSE.

 

How can I write this?

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Yes, indirectly through other tables.

  • Tahreem24's avatar
    Tahreem24
    Super User
    3 years ago

    Anonymous Try something like below as per your columns and table names

     = IF(FactAppointment[NewPatient]= TRUE AND FactSales[FirstSale] = TRUE AND FactAppointment[UserID]  = FactSales[User ID], True(),False())

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      It says the syntaxis is incorrect. I suspect because there's no direct relation between FactAppointment and FactSales.