Forum Discussion

JOSERB's avatar
JOSERB
Frequent Visitor
6 years ago
Solved

Calculated column with values from another table

Hi all, I need your help for a relatively simple topic, but I cannot make it work as I would like to.  The goal is to add a calculated column from a table 2  into table 1, which are already con...
General Comment
Need Help
Tips and Tricks
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi JOSERB ,

     

    Have you tried to change the ID column of Table 2 to the text category to create a relationship?

    After I try to do this, I can get the expected result based on the sample data provided by you by using the related function.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

JOSERB's avatar
JOSERB
Frequent Visitor
6 years ago

HI ibarrau 

In fact I do not want to do a "many to many" relationship. I think It should be a "one to many" being "one" Table2, which is the filter of Table1, but PBI only allows me to do a "many to many" relationship between both tables. 
The Accept button does not work.... 

JOSERB's avatar
JOSERB
Frequent Visitor
6 years ago

In fact, If I tried only to match ID1 with ID2 with RELATED(TABLE2,[ID2]), I find an error message that says " there is no relationship or it does not exist betwen both tables in the current context...  and the relationship I have created is indeed  ID1 = ID2!
Definately I am lost...