Forum Discussion

marabeda's avatar
marabeda
Helper I
4 years ago
Solved

Create a calculated columns from 2 tables

Dear Community, I have these 2 tables: Table1 Table2 The relationship between tables is many-to-many with column Client My objective is to have two calculated columns in Table1 where ...
marabeda's avatar
marabeda
Helper I
4 years ago

Hi technolog, it works! thank you. I solved first part of the question. The second part is how to show the value in table2[ore] in a column that match client in table1. Can you help? Can I write the same formula?

Many Thx

 

  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    Community Support
    4 years ago

    Hi marabeda ,

     

    I am very happy that your problem is solved, please mark it so that more people with the same problem as you can find the answer quickly!

     

    Best Regards

    Community Support Team _ chenwu zhu

  • technolog's avatar
    technolog
    Super User
    4 years ago

    Yes, you can use the same formula - only replace Table2 to Table1 and all will work. 

    Text me when it works.

  • technolog's avatar
    technolog
    Super User
    4 years ago

    marabeda is it all right? Are you need more help?