Forum Discussion

Kristofferaabo's avatar
Kristofferaabo
Helper IV
8 years ago
Solved

lookup between tables

Hi! I have a table which is linked to two tables thorugh the same relationship: "Project number"   I now want to make a column which returns 'Yes' if the given project number is in either of the l...
Need Help
Show and Tell
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    HI Kristofferaabo

     

    Try this COlumn

     

    Column =
IF (
    OR (
        CALCULATE ( COUNTROWS ( LinkedTable1 ) ) > 0,
        CALCULATE ( COUNTROWS ( LinkedTable2 ) ) > 0
    ),
    "Yes"
)
Kristofferaabo's avatar
Kristofferaabo
Helper IV
8 years ago

It also asked for a table? I guess it suppose to be columns?

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

Hi Kristofferaabo

 

This is a DAX formula for a calculated column in Table A

 

When I use this formula using some dummy data...it works

 

Could you show the screen shot of the error you get?? or share your file??

  • Kristofferaabo's avatar
    Kristofferaabo
    Helper IV
    8 years ago

    Hi! I think did something weird in the relationship! it works now.. ! Your solution is great thanks!