Forum Discussion

Kristofferaabo's avatar
Kristofferaabo
Icon for Helper IV rankHelper 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
Icon for Helper IV rankHelper IV
8 years ago

No i cant get powerBI to find/suggest the tables, I tried the RELATED function also...

Kristofferaabo's avatar
Kristofferaabo
Icon for Helper IV rankHelper IV
8 years ago

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

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Icon for Community Champion rankCommunity 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
    Icon for Helper IV rankHelper IV
    8 years ago

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