Forum Discussion
Join and add data from tables with multiple data
HI, Groups,
I need your help.
I have a table with the following data:
| Fill Rate | |
| Sales Ordes | Qty Invoice |
| OV1 | 8 |
| OV2 | 9 |
| OV3 | 9 |
and another table with the following data
| Detail Invoide | ||
| Sales Ordes | Qty Order | Qty Ship |
| OV1 | 8 | 4 |
| OV1 | 8 | 4 |
| OV2 | 9 | 3 |
| OV2 | 9 | 3 |
| OV2 | 9 | 3 |
| OV3 | 9 | 6 |
| OV3 | 9 | 3 |
I need to add 1 column to the fill rate table that keeps me the value of the ordered qty of the OV detail table
Result:
| Fill Rate | ||
| Sales Ordes | Qty Invoice | QTY Order |
| OV1 | 8 | 8 |
| OV2 | 9 | 9 |
| OV3 | 9 | 9 |
Thanks
Hi RicardoLeivaG ,
If the two tables have relation with Sales Orders Column, we can create a calculated column to meet your requirement:
QTY Order = CALCULATE(MAX('Detail Invoide'[Qty Order]),RELATEDTABLE('Detail Invoide'))If it does not meet you requirements, could you please make a more complex table or explain the logic of how to get the QTY Order column?
Best regards,
3 Replies
RicardoLeivaG I'm sure you have already added a relationship of these to tables, add a measure
Qty Ordered = MAX ( SalesDetail[Qty Ordered] )In table visual, use sales order and qty invoice from sales table, and this Qty Ordered measure
Dear:
I tried his soucion but he doesn't show me the data, it just brings me the highest value in the table. 😞Hi RicardoLeivaG ,
If the two tables have relation with Sales Orders Column, we can create a calculated column to meet your requirement:
QTY Order = CALCULATE(MAX('Detail Invoide'[Qty Order]),RELATEDTABLE('Detail Invoide'))If it does not meet you requirements, could you please make a more complex table or explain the logic of how to get the QTY Order column?
Best regards,
