Forum Discussion
Subtract the 3 dates from different tables
Hello, I have Table2[dateBefore], Table1[dateBegin] and Table1[dateEnd]. So, I need to subtract the 3 dates, so I can have the result in DAYS: so something like Table2[dateBefore] - Table1[d...
if all the IDs in those tables are unique, you can try to add a new step in table1
NewStep=Table.AddColumn(Table1,"DateDiff",each let a=Table2{[ID=[ID]]}?[dateBefore]? in a=null then null else Duration.Days(a-[dateEnd]-[dateBegin]))