Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (11.1k points)

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 

1 Answer

+1 vote
by (22.5k points)
edited by

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.  

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Browse Categories