Question

Most recent purchase dates of a customer in tableau.

Answer 1

Hi Smitha,

Follow below steps:

1. Create a calculated field like below. (find max(date) then compare with dates for each customer

      IF [Order Date]={ FIXED [Customer ID] : MAX([Order Date]) } THEN [Order ID]
      ELSE "NO"
      END

2. Now add the created field to filter ans unselect "NO".

3. Now the last or recent purchased order will be shown.

Hope this helps you.