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.
Go to Solution.
pls see the attachment below
Proud to be a Super User!
View solution in original post
could you pls provide the sample data and expected output?
Both NULL records in 1st table should be filled with the Productiondate from the 2nd table.
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!