First date with sales greater than 100 in TABLEAU

Question

I have a basic flat file which has Sales by date and product

1st calculated field has sales which are greater than 100 units

I have tried

 {FIXED [Style Code]: MIN([Prod Cal Activity Date])}

It gives me the 1st day sales

IF ([Net Sales Units]>200) THEN {FIXED [Style Code]: MIN([Prod Cal Activity Date])}END 

This also gives me the 1st day sales 

Answer 1

Use the following formula

MIN(IF([Net Sales Units]>100) THEN [Prod Cal Activity Date] ELSE #2100-01-01# END)

If you want to learn more about it Tableau, then go through this Tableau Online Training for more insights.