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])

[ryan_mayu]

@Anonymous 

Is this what you want?

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

[Anonymous]

@ryan_mayu ,

Classification is not a column in the Tabel2, It need to be calculated. thanks

[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.

[ryan_mayu]

@Anonymous 

Please try this measure

Measure = maxx(FILTER('Table1 (2)','Table1 (2)'[orderid]=RELATED('Table'[orderid])),'Table1 (2)'[Classification])

[Anonymous]

@ryan_mayu ,

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 

Sorry I am a little confused about this. The first solution I provided is to create a column.

The second solution is for you to create visuals.

You want to show the classification in table 2, then you use the first solution. You want to display the corresponding classification in table 2, you can just drag order ID from table 2 and classification from table 1 to achieve.

[Anonymous]

My Tabel2 is only like below. @ryan_mayu 

OrderID

A1

B2

C3

I need a calculated column called Revision lookingup the Classification column in Tabel1. Matching coloumn is OrderID for both tabel.

[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])

[Anonymous]

@ryan_mayu , you were correct, I maanged to find anther column to get the desired value. thanks a lot for the help

[ryan_mayu]

@Anonymous  nice to hear that. vlookup in excel wont get error because it will always get the first value in the list.

[Anonymous · Accepted solution]

@ryan_mayu , thanks for the reply.

I tried the column it gives me below error

[ryan_mayu]

@Anonymous 

I am guessing your sample data is not fully matching your real data.

do you have differernt status for each ID? if so, lookupvalue does not work.

[Anonymous]

Hi Ryan, 

Order ID is the unique id for both tabel, in excel I can get the value of table 1 from just by vlookup. need to replicate that in dax. 

does that answer your question.