Forum Discussion
Helper IUsing IF function to reference a related table
Hello,
I am trying to create a DAX calculated column based on a column from a different table that has a relationship with the main table. I am experiencing some errors when trying to merge several tables with a SharePoint table. Is there a way to create a calculated column based on the relationship?
The two tables have relationship on ID and trying to create a calculated column on Table A based on a date column on Table B using IF function.
So is it possible to use IF function to reference a related table?
Left side is table1 and right side is table2.
| ID | Date1 | Calc Col | ID | Date2 | ||
| 1 | 1/1/2022 | IF(Date1==Date2, 1, 0) | 1 | 1/1/2022 | ||
| 2 | 3/1/2022 | IF(Date1==Date2, 1, 0) | 2 | 3/1/2022 | ||
| 3 | 4/2/2022 | IF(Date1==Date2, 1, 0) | 3 | 4/2/2022 |
Hi,
if i understood your problem you can try this calculated column
Column = var CurrId = 'Table'[ID]var result = if('Table'[Date1 ]= Related('Table (2)'[Date2]),1,0)returnresultIf this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
2 Replies
- serpiva64
Solution Sage
Hi,
if i understood your problem you can try this calculated column
Column = var CurrId = 'Table'[ID]var result = if('Table'[Date1 ]= Related('Table (2)'[Date2]),1,0)returnresultIf this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
dcrossetoResolver II
Hi cferv_77,
If you're having troubles with the relationships, you can disable it and try to apply manually using USERELATIONSHIP.
And then create a measure like this, you can also apply some conditional like you mentioned.
Measure = CALCULATE( SUM(Table1[Value]), USERELATIONSHIP(Table1[Id],Table2[ID]) )Hope it was helpful.
Regards,
Douglas.