Show only products with a min order date in last 90 days

[ManuelLindekeit]

Hi All, 

I have a create a report that shows only Products that have sold for the first time in the past 90 days. 

Does anyone have an idea how to accomplish this? Here is my unsuccessful attempt. 

Count({$<min([Order Date])={">$(=date(Today()-30))"}>}[OrderLines.Order Number])

Thanks in advance.

[JuanGerardo · Accepted solution]

Hi @ManuelLindekeit, I think this is a candidate for the E() function in set analysis:

Count({<[OrderLines.Order Number]=E({1<[Order Date]={"<$(=date(Today()-30))"}>})>} [OrderLines.Order Number])

JG