Forum Discussion

marabeda's avatar
marabeda
Icon for Helper I rankHelper 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 ...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi marabeda 

The RELATEDTABLE ( Table2 ) will return two rows for each row in Table1. There must be another column to be matched in order to filter it down to one row. Ror examole a date or a month. Otherwise this cannot be achieved 

  • marabeda's avatar
    marabeda
    Icon for Helper I rankHelper I
    4 years ago

    Thank you for your interest. I do not have another column. These are the 2 tables. I can avoid having two row only if I create a table like this:

    where the headers are the days of the week and each row contains the name of the client and when I have to execute the job for the client.

    But with this table, I do not know how to verify in Table1 if the day (Table1[giorno]) when I have executed the job is the day that I have programmed in Table2.

    I hope this help to explain better what I want to achieve.

    Thank you