Forum Discussion

Frequent Visitor

5 years ago

need help

hi everyone I need to look for the same part name according to the order date between the order date and + 3 days more spare for exaple: the first line on the order table with part name A-123...

Community Champion

5 years ago

davidibi4524 Maybe:

Measure = 
  VAR __PartName = MAX('ORDERS'[part name])
  VAR __MinDate = MAX('ORDERS'[date])
  VAR __MaxDate = __MinDate + 3
  VAR __Table = FILTER('INVOICES',[part name]=__PartName && [date] >= __MinDate && [date]<=__MaxDate)
RETURN
  SUMX(__Table,[quantity])

davidibi4524

Frequent Visitor

5 years ago

going to try it