Need help with comparing values

[Sashwato]

Hello all,

I am trying to get a solution regarding comparison of values between two dates. In my model, I have the date range set to last 31 days (Currently it will pick up PRICE values from March 7 to Feb 6, 2021 due to model not refreshed from past 2 weeks)

I have a PRODUCT_ID column for which I want to compare the price between two dates. Those dates will be the recent date (price date near to today's date for which record is available) and the earliest date available within 31 days range. Check screenshot below:

In the above, I selected a specific PRODUCT_ID and if you see March 2 value is higher than February 6 value, therefore it is a price increase status. Hence this PRODUC_ID would be counted into list of unique product counts for increased price.

Similar situation can happen for decrease in price as well. So, we need to count how many unique count of products decreased. If there is no increase in price, that count will not be considered. 

Please let me know if there is a viable solution to this issue. Appreciate your help if anyone can help me.

[lbendlin]

Please provide sample data in usable format (not as a picture) .