1 of 1 people found this helpful
I think you'll want to try flipping the equation around. The order in which you list variables matters in the DATEDIFF calculation. You'll want to change the order since you are now looking at Maximums instead of Minimums.
DATEDIFF('day',MAX([Order Date]),WINDOW_MAX(MAX([Order Date])))
The two different methods gave me slightly different results. After looking at the data in Excel and comparing my manual calculations to the Tableau calculated fields, it looks like DATEDIFF('day',MAX([Order Date),TODAY()) is the most accurate (also much simpler!)