How many entries in the table for this customer =CALCULATE(COUNTROWS(Changes),filter(Changes,Changes[member_id]=EARLIER(Changes[member_id]))) How many entries in the table for this customer that are of change_type "type" =CALCULATE(COUNTROWS(Changes),filter(Changes,Changes[member_id]=EARLIER(Changes[member_id])),FILTER(Changes,Changes[change_type]="Type")) what is the last date for this table =CALCULATE(max(Changes[start_date]),filter(Changes,Changes[member_id]=EARLIER(Changes[member_id])),FILTER(Changes,Changes[change_type]="Type")) Turn it into a table =COUNTROWS(CALCULATETABLE(Changes,filter(Changes,Changes[member_id]=EARLIER(Changes[member_id])),FILTER(Changes,Changes[change_type]="Type"))) return the date of the type transaction I need to use =var thisStartDate = Changes[start_date] return CALCULATE(max(Changes[start_date]),filter(CALCULATETABLE(Changes,filter(Changes,Changes[member_id]=EARLIER(Changes[member_id])),FILTER(Changes,Changes[change_type]="Type")),Changes[start_date]