Forum Discussion

aadass's avatar
aadass
Frequent Visitor
8 years ago
Solved

Problem to use DATEDIFF function between two dates which located in two not directly related tables

Problem to use DATEDIFF function between two dates which located in two but not directly related tables. Task: Stock.Registration_Date - Invoices.InvoiceDate   Formula: NeedDate= DATEDIFF([R...
aadass's avatar
aadass
Frequent Visitor
8 years ago

Sam,

i think it solved my issue:

 

Weeks in stock = DATEDIFF([Registration_Date],MAXX(RELATEDTABLE(Invoices),Invoices[InvoiceDate]),WEEK)

 

I would never thought that MAXX  can act as a little liason between "unrelated" tables 

 

 

Thank you much

 

Angelika