Using IF function to reference a related table

[cferv_77]

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

[dcrosseto]

Hi @cferv_77, 

If you're having troubles with the relationships, you can disable it and try to apply manually using USERELATIONSHIP.

https://prnt.sc/LZ8qTEt2TW4n

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.

[serpiva64 · Accepted solution]

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)

return

result

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !