Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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.
Hi All
Can some one share with me where go wrong on the below expression , it does not work .
Paul
Below link is my PBI :-
https://www.dropbox.com/s/iw8vwmghei8b0g6/PBT_V2021_333%20LINK%20PRODUCT%20CLASS.pbix?dl=0
Paul
I also try to change sales and inventory table product class code to text format , it still get the same error.
Paul
@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
@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?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
183 | |
111 | |
105 | |
77 | |
70 |