Forum Discussion

cferv_77's avatar
cferv_77
Icon for Helper I rankHelper I
3 years ago
Solved

Using 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...
Need Help
  • serpiva64's avatar
    serpiva64
    3 years ago

    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 !

     

dcrosseto's avatar
dcrosseto
Icon for Resolver II rankResolver II
3 years ago

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.