Forum Discussion
Solved
Extract dates from separate tables
I need to create a new column in my data showing the due date for items however some of my items have a due date where the value of the due date is in a seperate table. In the original table there is...
Hi,
Write this calculated column formula in Table1
Column = CALCULATE(MAX(Table2[Date]),FILTER(Table2,Table2[Serial Number]=EARLIER(Table1[Serial Number])&&Table2[Instance]=EARLIER(Table1[Instance])))Hope this helps.
Thank you! That worked.
You are welcome.