Date filters in Tableau - Cell-by-Cell Formula Trace

Sample Data

This data shows sales amounts for orders placed on different dates.

Cell	Value
A1	Order Date
A2	2024-01-10
A3	2024-02-15
A4	2024-03-20
A5	2024-04-25
B1	Sales
B2	100
B3	200
B4	150
B5	300

Formula Trace

IF [Order Date] >= DATE('2024-02-01') AND [Order Date] <= DATE('2024-03-31') THEN [Sales] ELSE 0 END

Step 1: [Order Date] >= DATE('2024-02-01')

Step 2: [Order Date] <= DATE('2024-03-31')

Step 3: [Order Date] >= DATE('2024-02-01') AND [Order Date] <= DATE('2024-03-31')

Step 4: IF condition THEN [Sales] ELSE 0

Cell Reference Map

Order Date

↓

Sales

The formula uses the Order Date column (A2 to A5) and Sales column (B2 to B5) to filter sales by date.

Result

     A           B          C
1  Order Date   Sales    Filtered Sales
2  2024-01-10   100          0
3  2024-02-15   200        200
4  2024-03-20   150        150
5  2024-04-25   300          0

The Filtered Sales column shows sales only for orders between Feb 1 and Mar 31, 2024. Other sales are zeroed out.

Sheet Trace Quiz - 3 Questions

What does the condition [Order Date] >= DATE('2024-02-01') check?

A If the order date is exactly February 1, 2024

B If the order date is before February 1, 2024

C If the order date is on or after February 1, 2024

D If the order date is after March 31, 2024

Key Result

IF [Date] >= StartDate AND [Date] <= EndDate THEN [Measure] ELSE 0 END