Forum Discussion
Lookup valued from one table to another table column
Hi Gurus, can you please help me with below request. I need a new column called Classification in Tabel2 looking up the Tabel1 relationship is One to Many from Tabel2 to Tabel1 ...
Anonymous
Is this what you want?
Creating a Revision column in table 2
Revision= LOOKUPVALUE('Table1 1'[Classification],'Table1 1'[orderid],'Table 2'[orderid])
ryan_mayu
Super User
Super UserAnonymous
Is this what you want?
Classification = LOOKUPVALUE('Table1 (2)'[Classification],'Table1 (2)'[orderid],'Table'[orderid])
- ryan_mayu
Anonymous
Please try this measure
Measure = maxx(FILTER('Table1 (2)','Table1 (2)'[orderid]=RELATED('Table'[orderid])),'Table1 (2)'[Classification])I do not have a column called Classification at the moment in Tabel2.
Requirement is to created a calcualted column looking that column from Table1. apologies for not being clear
- ryan_mayu
Anonymous
I think if you created the relationship between two tables. you don't need to create a measure.
Just drag the order ID from table 1 and classification from table 2.