Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Add column from many to 1 table

Greeting all ,    im trying to add a column from a table to another one ( the relation between them is many to 1 )  here is a sample :  Table 1 : Table 2 :     im trying to add th...
  • aj1973's avatar
    5 years ago

    Hi Anonymous 

    Here you go

     

    Category_ = CALCULATE(SELECTEDVALUE('Table 1'[Category]), USERELATIONSHIP('Table 1'[Class Num],'Table 2'[Class Num]))