need help

Question

hi everyoneI need to look for the same part name according to the order date between the order date and + 3 days more sparefor 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 :))&nbsp;&nbsp;

davidibi4524 · Answer

going to try it

greg_deckler · Answer

davidibi4524&nbsp;Maybe:
Measure = 
  VAR __PartName = MAX('ORDERS'[part name])
  VAR __MinDate = MAX('ORDERS'[date])
  VAR __MaxDate = __MinDate + 3
  VAR __Table = FILTER('INVOICES',[part name]=__PartName &amp;&amp; [date] &gt;= __MinDate &amp;&amp; [date]&lt;=__MaxDate)
RETURN
  SUMX(__Table,[quantity])

davidibi4524 · Answer

i can't sum this measure..what i can do?

greg_deckler · Answer

davidibi4524&nbsp;Well, measure aggregation is a slightly different topic.&nbsp;See my blog article about that here: https://community.powerbi.com/t5/Community-Blog/Design-Pattern-Groups-and-Super-Groups/ba-p/138149The 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.

ashish_mathur · Answer

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

Forum Discussion

need help

6 Replies