cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

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 linked tables.

 

Makes sense?

Krsitoffer

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: lookup between tables

HI @Kristofferaabo

 

Try this COlumn

 

Column =
IF (
    OR (
        CALCULATE ( COUNTROWS ( LinkedTable1 ) ) > 0,
        CALCULATE ( COUNTROWS ( LinkedTable2 ) ) > 0
    ),
    "Yes"
)
9 REPLIES 9
Super User
Super User

Re: lookup between tables

HI @Kristofferaabo

 

Try this COlumn

 

Column =
IF (
    OR (
        CALCULATE ( COUNTROWS ( LinkedTable1 ) ) > 0,
        CALCULATE ( COUNTROWS ( LinkedTable2 ) ) > 0
    ),
    "Yes"
)

Re: lookup between tables

Hi,

 

@Zubair_Muhammad thanks for your input! always a pleasure! 

 

Below is by relationships, table A, B and C all have the column 'Project'. I would like to be able to have column in table A indicating whether the project is also present in table B and C. Either with a Yes, or 1 or similar..

 

That way I can filter it off/on

 

Thanks

Kristoffer

 

PBI_columns.jpg

 

Super User
Super User

Re: lookup between tables

Hi

Did you try the above formula?

Re: lookup between tables

Yes, perhaps I misunderstand it, but it found 'find' the columns..

I tried this:

Column =
IF (
    OR (
        CALCULATE ( COUNTROWS ( TABLE B [Project] ) ) > 0,
        CALCULATE ( COUNTROWS ( TABLE C [PROJECT] ) ) > 0
    ),
    "Yes"
)
Super User
Super User

Re: lookup between tables

It worked?

Re: lookup between tables

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

Re: lookup between tables

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

Super User
Super User

Re: lookup between tables

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??

Re: lookup between tables

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