{ FIXED YEAR([Order Date]), [Customer ID]: COUNTD([Order ID]) } { FIXED [Customer ID]: MIN(YEAR([Order Date])) } RUNNING_SUM(COUNTD([Customer ID])) [Running Total]/ SUM({ FIXED [Customer Cohort]: COUNTD([Customer ID])})
{ FIXED YEAR([Order Date]), [Customer ID]: COUNTD([Order ID]) } { FIXED [Customer ID]: MIN(YEAR([Order Date])) } RUNNING_SUM(COUNTD([Customer ID])) [Running Total]/ SUM({ FIXED [Customer Cohort]: COUNTD([Customer ID])})