Fixed Calculation Tableau Direct

Create the Boolean Flag.

But what if you want the FIXED calculation to respect the year? fixed calculation tableau

Have you used FIXED to solve a tricky business problem? Share your example in the comments below. Create the Boolean Flag

You try a standard calculation: MIN(Order Date) . Share your example in the comments below

This is wrong. You need a calculation that ignores the date filter. The FIXED calculation tells Tableau: "Compute this value using these specific dimensions, and ignore all other filters (except context filters and data source filters)." The Syntax FIXED [Customer Name] : MIN([Order Date]) Translation: "Lock onto each unique Customer. Look at all the Order Dates available for that customer (ignoring my current date filters). Give me the very first one." Real-World Example: Customer Retention Imagine you want to know how many new customers you acquired each month.