Forum Discussion
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...
Try this COlumn
Column = IF ( OR ( CALCULATE ( COUNTROWS ( LinkedTable1 ) ) > 0, CALCULATE ( COUNTROWS ( LinkedTable2 ) ) > 0 ), "Yes" )
Hi
Did you try the above formula?
Did you try the above formula?
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"
)- It worked?
No i cant get powerBI to find/suggest the tables, I tried the RELATED function also...
It also asked for a table? I guess it suppose to be columns?