How to bring a column from another table with a condition

[Syndicate_Admin]

Dear, I have created a new table (float error) from the chemical table. However I need to create 1 column with the Cu (%) data of the chemical table, but with a condition, Sample Type = CAB

Best regards

Violet

Chemistry

Float error

[Anonymous · Accepted solution]

Hi  @Syndicate_Admin ,

Here are the steps you can follow：

1. Create calculated column.

Cu% CAB =
SUMX(FILTER(ALL('Table'),'Table'[ID Muestra]=EARLIER('Table2'[ID Muestra])&&'Table'[Tipo Muestra]="CAB"),[Cu(%)])

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[JW_van_Holst]

Most obvious solution is to include the columns you want to reference in your calculated table. If this, for some reason, is not desirable, you are left with to option.

1. Link the tables in het modelling tab and use RELATED
2. Without a link, use LOOKUPVALUE.