need help

[davidibi4524]

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 maching to the first line on the invoice table because the date is in the range of 13/08/2021 + 3 (between 13/08/2021 and 16/08/2021)

can someone help me find the right dax formula to build the desired table?

thanks :))

[v-angzheng-msft]

Hi,  @davidibi4524 

Why does A-456 match the invoice quantity of 2000, and isn't the part name of the invoice quantity of 2000

A-123? Am I missing something?

Best Regards,
Community Support Team _ Zeon Zheng

[Ashish_Mathur]

Hi,

I suggest that you write a calculated column formula in the Orders table.  Are you interested in that solution (instead of a measure)?

[Greg_Deckler]

@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]

i can't sum this measure..

what i can do?

[Greg_Deckler]

@davidibi4524 Well, measure aggregation is a slightly different topic. See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149

The pattern is:
MinScoreMeasure = MINX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
MaxScoreMeasure = MAXX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
AvgScoreMeasure = AVERAGEX ( SUMMARIZE ( Table, Table[Group] , "Measure",[YourMeasure] ), [Measure])
etc.

[davidibi4524]

going to try it