Forum Discussion
Solved
add custom column based on 2 different tables
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
3 Replies
could you pls provide the sample data and expected output?
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.
