Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
@Sohan 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())
It says the syntaxis is incorrect. I suspect because there's no direct relation between FactAppointment and FactSales.
Yes, indirectly through other tables.
User | Count |
---|---|
75 | |
75 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |