Determine a new column based on other table lines

[Anonymous]

Hi everybody,

I'm trying to determine a new column based on information of multiple lines from another table.

I really do not know how to do that and would appreciate your help.

You'll find an image to show what I expect.

In green -> 'Fixe' when all the lines for the 'Paquet' in column 'Longueur' are the same

In blue ->'Variable' when all the lines for the 'Paquet' in column 'Longueur' are not the same

Thanks for your help.

[philouduv · Accepted solution]

Hey @Anonymous ,
If you just need to fill the second table type and that the first column is created with the differents paquet use :

Type= CALCULATE(IF(DISTINCTCOUNT(Table1[longueur]) == 1, "Fixe","Variable"))

Best regards

[amitchandak]

@Anonymous , Try like a new column in Table 1

maxx(filter(Table2, Table1[Paquet] = Table2[Paquet]), Table2[Type])

refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

[Anonymous]

Thanks @amitchandak ... I think my image was not clear enough...