Forum Discussion
cferv_77
Helper I
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 sever...
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 !
serpiva64
Solution Sage
Solution SageHi,
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 !