Unfortunately, one cannot do everything recursive with LODs only, sorry.
The two main approaches are used, namely, a non-equi join or a window calculation.
Both ways are feasible when using Tableau.
While the former (via join) relays upon a DBMS of choice,
the latter could be done either in SQL (using window functions)
or in Tableau itself (using Table Calculations).
Please find the attached as an example of the latter.
Hope it could help.
Days from Prev Order ID.twbx 1.3 MB
This was actually how I had initially done it too. I have a few other conditions to build in, (such as days since previous *specific product* purchase, but this is a good foundation to start on, so thank you again.