Hi upwardD,
Good question. Find a possible solution attached.
One note: You ask the difference between first purchase and last purchase in the first part of question, but then ask the difference between first purchase and next purchase further down. I assumed you meant first and last purchase date, so that is what I implemented. Days_Between 1st_and_Last_Purchase.pbix (221.6 KB)