Lookup valued from one table to another table column

[Anonymous]

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 

@ryan_mayu 

[ryan_mayu · Accepted solution]

@Anonymous 

Is this what you want?

Creating a Revision column in table 2

Revision= LOOKUPVALUE('Table1 1'[Classification],'Table1 1'[orderid],'Table 2'[orderid])