find minimum value from a specified date

Shaaz

I've a data at Country and InvoiceDate level and Price of it. I need to find MinPrice in last 60days at each country and date level.

For a Country and InvoiceDate, I need to find the lowest Price in the past 60Days from the current InvoiceDate.

In layman words,

For a country India, if InvoiceDate is 3rd Dec'21, then I'll go back 60 days (which will be 4th Oct'21), so I need have minimum price between these dates.

JarekSkudrzyk

@Shaaz here you go (solution based on this article: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-106-How-Long-were-the-Lights-On/td-p/142023)

minimum price.yxmd