add custom column based on 2 different tables

[jdevalk77]

Hi, I need some help;

I have 2 tables with a production date and both are linked with an ordernumber.

Now I would like to add a custom column;
If 'table1'[ordertype] = "open" THEN 'table1'[Productiondate] ELSE 'table2'[Productiondate]

Does anyone know what formula I should use?
Thanks in advance.

BR,

Jurgen

[ryan_mayu]

could you pls provide the sample data and expected output?

[jdevalk77]

Table1:

Order	Ordertype	Productiondate
1234	Queue	26-11-2022
2345	Queue	28-11-2022
3456	Open	NULL
4567	Queue	30-11-2022
5678	Open	NULL

Table2:

Order	Productiondate
3456	29-11-2022
5678	30-11-2022

Both NULL records in 1st table should be filled with the Productiondate from the 2nd table.

[ryan_mayu · Accepted solution]

@jdevalk77 

pls see the attachment below