Posts

Showing posts from July, 2025

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 )