Text Data
YearsCompleted = VAR StartDate = 'Table'[DOJ] VAR EndDate = DATE(2025,3,31) RETURN DATEDIFF(StartDate, EndDate, YEAR) - IF ( MONTH(EndDate) < MONTH(StartDate) || (MONTH(EndDate) = MONTH(StartDate) && DAY(EndDate) < DAY(StartDate)), 1, 0 )