How to bring pro_class_desc field from sales table to inventory table ?

[admin11]

Hi All

My inventory table only have pro_class don’t have pro_class_desc

But my sales Table have both pro_class and pro_class_desc

My question is what is the best approach to make inventory table have pro_class_desc ?

Inventory Table :-

stock_code......pro_class......

1.........................1111

2.........................2222

3.........................3333

Sales Table :-

stock_code......pro_class......pro_class_desc......

1.........................1111................Terminal Block

1.........................1111................Terminal Block

1.........................1111................Terminal Block

2.........................2222................Servo Motor

2.........................2222................Servo Motor

2.........................2222................Servo Motor

3.........................3333................PLC

3.........................3333................PLC

3.........................3333................PLC

3.........................3333................PLC

Final Result expected :-

Inventory Table :-

stock_code......pro_class......pro_class_desc......

1.........................1111................Terminal Block

2.........................2222................Servo Motor

3.........................3333................PLC

Paul

[v-lionel-msft]

Hi @admin11 ,

Please refer to the formula.

Column = 
LOOKUPVALUE(
    'Sales Table'[pro_class_desc],
    'Sales Table'[stock_code], 'Inventory Table'[stock_code],
    'Sales Table'[pro_class], 'Inventory Table'[pro_class]
)

Best regards,
Lionel Chen

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

[admin11]

@v-lionel-msft 

Hi All

Can some one share with me where go wrong on the below expression , it does not work .

Paul

[admin11]

@v-lionel-msft 

Below link is my PBI :-

https://www.dropbox.com/s/iw8vwmghei8b0g6/PBT_V2021_333%20LINK%20PRODUCT%20CLASS.pbix?dl=0

Paul

[admin11]

@v-lionel-msft 

I also try to change sales and inventory table product class code to text format , it still get the same error.

Paul 

[admin11]

@v-lionel-msft Thank you very much for sharing with me the approach.

Both my sales and inventory table the stock code format is text. for example stock code = N1234

Both sales and inventory product class code format is whole number. 

I get below error msg :- 

May i know where go wrong ?

Paul

[parry2k]

@admin11 I believe these two tables have a relationship and it is "one to many" relationships, one on the inventory side and many on the sales side, is this correct?

[admin11]

Hi All

Thank you for your sharing. I am not sure about your question. 

Below is my sales table.

Below is my Inventory Table :-

 PBi file :-

https://www.dropbox.com/s/sdeo7hjluuye4u2/PBT_V2021_313%20LINK%20PRODUCT%20CLASS.pbix?dl=0

Paul