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

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

Kristofferaabo's avatar
Kristofferaabo
Helper IV
8 years ago

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