Forum Discussion

RicardoLeivaG's avatar
RicardoLeivaG
Helper I
6 years ago
Solved

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 da...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    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,

     

RicardoLeivaG's avatar
RicardoLeivaG
Helper I
6 years ago

Dear:

 

I tried his soucion but he doesn't show me the data, it just brings me the highest value in the table. 😞
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

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,