Sum based on min and max date

[keithblythe]

Hello, I have a data set like the following:

Customer	Material	Price	Order Date	Ship Date	Quantity
XYZ	1111	7.95	6/30/2020	7/15/2020	100
XYZ	1111	7.95	6/30/2020	7/22/2020	200
XYZ	1111	7.95	6/30/2020	7/29/2020	100
XYZ	1111	7.95	6/30/2020	8/5/2020	300
XYZ	1111	7.95	7/6/2020	7/15/2020	100
XYZ	1111	7.95	7/6/2020	7/22/2020	400
XYZ	1111	7.95	7/6/2020	7/29/2020	100
XYZ	1111	7.95	7/6/2020	8/5/2020	300
XYZ	1111	7.95	7/13/2020	7/15/2020	0
XYZ	1111	7.95	7/13/2020	7/22/2020	200
XYZ	1111	7.95	7/13/2020	7/29/2020	100
XYZ	1111	7.95	7/13/2020	8/5/2020	500

I want to show as a KPI a summary of the quantity fields by min order date and max order date.  Show I would expect the following:

Order Date 6/30/2020 - Quantity = 700

Order Date 7/13/2020 - Quantity = 800

Any assistance with this calculation would be appreciated.

[dplr-rn]

soemthing like below

for min date Sum( {<Date={'$(Min(Date))'}>}  Quantity)

for max date Sum( {<Date={'$(Max(Date))'}>}  Quantity)

[keithblythe]

This returned a sum of all values instead of total by order date.

[PrashantSangle]

instead of sum() you should min() or max()

min date with max quantity

Max( {<Date={'$(Min(Date))'}>}  Quantity)

and 

max date with min quantity

Min( {<Date={'$(Max(Date))'}>}  Quantity)

Regards,

Prashant Sangle

[dplr-rn · Accepted solution]

sorry make $(= instead $(

for min date Sum( {<Date={'$(=Min(Date))'}>}  Quantity)

for max date Sum( {<Date={'$(=Max(Date))'}>}  Quantity)

[keithblythe]

I am still getting all records summarized with the revised set analysis.  If I filter by order date then I get a correct number but if the data is unfiltered then it is summarizing all records.

[dplr-rn]

got to data modelviewer check the column type of your date field. maybe something is messed up there.

it should have $numeric $date tags

below is a screenshot of an example in my local of a similar expression.