Maximum Date where products are bigger than zero and less than calculated date

I’m encountering an error while trying to create a custom column in Power Query in Excel. The goal is to implement two tests: