min if expression

[andreip21]

Hi all,

i have multiple products with price history by every date.

Ex:

Product	Date	Price
1	06/25/2018	10
1	06/26/2018	10
1	06/27/2018	8
2	07/02/2018	25
2	07/03/2018	29
2	07/04/2018	29

I want to calculate the minimum price for each product for a period of 7 days before a certain date:

Ex:

Product	Certain Date	Period of 7 days	Min Price
1	06/28/2018	06/21/2018-06/27/2018	8
2	07/10/2018	03/07/2018 - 07/09/2018	29

If it's possible, i want to calculate directly in a chart.

thanks a lot in advance,

Andrei

[its_anandrjs]

Hi,

Use RangeSum() for this

Regards

Anand

[sunny_talwar]

How is Certain Date determined in the example you gave above?

[andreip21]

certain date is another input (loaded file)

[sunny_talwar · Accepted solution]

You can try this

Min(If(Date >= [Certain Date] - 7 and Date < [Certain Date], Price))